I know lots of folks who did just that. I took classes with lots of them! The problem is figuring out what you want to do, and then the commitment to doing it.
Plenty of careers you could get with two years at the community college (ok, not going full time it would take longer but they offer summer classes too.)
Community college only offers associates degrees. Mostly kinda general ones.
On the bright side, if my CCAF credits transfer, I'm probably close to two-thirds of the way through a degree. I think I had sixty some credits and associates degrees (there, at least) are ninety.
I suppose the chances they'll take everything are slim, though.