Here's how I'd rank the five I've been to, based on how much I'd like to live there (of which college sports/plays/museums/lectures is a part), excluding factors like proximity to family, Wake games, etc. I do want to end up living in a college town, not only because of my career goal/handle.
1. Berkeley--great nature close by, all kinds of cultural restaurants/events, i could probably dig the weather. downside would be too many weird people and too big of a metropolitan area for my tastes.
2. Austin--great nature, huge, top university, but it is Texas, no matter how liberal, and freaking hot in the summer.
3. Chapel Hill--I like (miss) NC weather and pace of life, but it is snobby and the blue would bother me, I think.
4. Charlottesville--ditto what I said about Chapel Hill, minus the weather as a plus.
5. Ann Arbor--I lived there for three years. The university is great, the rest sucks. The restaurants are unbelievably bad, IMO. And the winters suck. Locals are nice, though.
Some others I have experience with:
State College--Ann Arbor lite. Remarkably similar, IMO, with the difference being that the students are dumber.
Morgantown--Although I'm among the few who like West Virginia (*high five* Kanhoji!), Morgantown is pretty depressing.
Annapolis--great restaurants/shops and right by the water, but it's snobby and uber-preppy and there's nothing else worth seeing in the vicinity w/o going to DC/Baltimore.