On a different thread I was able to provide some names of residential community colleges that did well in terms of their students getting degrees or transferring over to a 4-year college. How was I able to find those particular names? Because I had them in a spreadsheet as options to consider for my own child, should my child decide to go that route.
There is absolutely nothing wrong with community colleges. It is not, however, the same experience as attending a 4-year university for one’s entire time as an undergraduate. And OP has expressed the desire to attend a 4-year residential university.