For what it is worth,I go to a community college with a pro pilot program. Granted, I'm here for the Air Traffic Control program. Even so, the pro pilot program is pretty legit. There are 3 flight schools on the campus (the campus is at an airport) that you can choose from. Your flying is discounted when you do it as a degree. If you are instate (which I assume you'd be), the rest of your education would be discounted to a community college price. The program is only 1.5 years (4 consecutive semesters, no summer break) long and you'll get an associates degree. Then with the money you've saved, you could transfer your credits to a larger school and get a BS degree while you build your hours flying. Its not a bad option at all.
Here's the curriculum:
Also, just to give you some first hand experience. I did my freshman year at a good size 4 year school. I really enjoyed it, especially the social aspect of it. By that I don't even mean parties and stuff, I'm not much of a partier. But in the 2 semesters I was there were probably the best 8 months of my life. That being said, the education side of things really dragged. I didn't want to spend 4 years getting a generic bachelor degree. Long story short, I ended up moving up here for the ATC program.
I'm not saying that one way is better than another. They are just different. I guess the only advice I'll give you is don't pigeonhole yourself into something you don't enjoy, evolve. There are a lot of ways to skin a cat.