That's one thing I think is good about the California state system. I know some very intelligent people who went to community college first and then transferred to a UC to finish, because they didn't have the high-school grades to get into a "good" school directly, but the public university system is designed for that kind of transfer to be possible (there is a specific transfer process, and in addition the 4-year college degree programs must be designed so that transferring in is possible, with prereqs fulfillable via community college courses).
I'm pretty sure it's like that most places, being a community college -> state university transfer myself (in Illinois), and knowing plenty of other people who went from community college to Northwestern and a few other nice private colleges. Anything out of your degree's core reqs. seems to usually be easy to transfer from community college, and that's usually what the first 2 years are. CC is also a good place for knocking out your math requirements, and a lot of the people in my math classes were traditional university students doing it to save money, or to get it done during a summer semester at home.
Problems might be more from not having a decent community college to go to, families that think community college is unacceptable, or just slacker inertia. I had an excellent community college, and went back to school as an adult over 10 years after dropping out of high school, so none of that stuff applied to me.
I agree. I went to a community college before transferring to the University of California, San Diego. I had an excellent experience at my CC; smaller class sizes, dedicated teachers,ect..I felt I got more value out of it than the big classes at UCSD. Where, like most big universities, the teachers there were there mostly for research. I did get a lot of shit for it though. A lot of condescending people who jump to the conclusion that I was unmotivated and stupid because I went to a CC.