I currently go to a state university in the mountains, and while I love the area and the school, I'm probably going to wind up transferring to a community college in a different city for a number of reasons.
It's been somewhat hard for me to make friends where I'm at now, simply because I never stayed in the dorms (transferred in as a sophomore and got an apartment because the dorms were full). I consider the people I work with friends, but they're a bunch of introverted computer people, and that's all most of them do. Most of them also have wives and girlfriends, so they're covered in that regard.
There are also a lot of hippies where I go. This isn't necessarily bad unless you meet the wrong kind. There are smelly hippies, there are super liberal vegan feminist hippies, there are patronizing self-important hippies that nag you about everything you do, and many other kinds. There are also super-friendly hippies, but I've met fewer of these than the former.
Sadly, I don't feel like I have a lot in common with most of the people I go to school with. Generally I like most of the people I meet there, but it's hard for me to make a deeper connection with someone when I'm not forced to be around and talk with them. I'm trying to fix this by actually going to clubs this semester, but it may be too little, too late.
As much as I like the mountains, the school, and my job, it's a four-hour drive from my home, and I don't have a lot of money to repair my car with should something happen. The snow has already taken its toll on my paint job. I don't know what I'd like to do with my life; I'm currently a Psychology major but I don't think I'd want to go to grad school for it. Looking at it from an objective standpoint, I'm essentially wasting money by going to school for something that I probably won't wind up doing. These are a few reasons I'm considering a move.
If I move to Raleigh, I can go to Wake Tech for a Computer Engineering certification. It would be much cheaper, I'd be around my friends in a pretty large city with much more to do, and it would be far easier to get a better-paying job. It's probably not something I want to do for the rest of my life, but it's better than wasting time and I'll be that much closer to being self-reliant. I hate borrowing money from my dad.
To me, it seems as though college is great for some people and not so great for others. If you absolutely know what you want to do (or at least think you can figure it out within two years) and have the drive to study and work for it, I'd say it will probably be one of the greatest experiences of your life. If you don't, then you'll probably have fun regardless, but you might wind up like me: in the hole a few thousand dollars with nothing to show for it.