With the internet, shopping isn't important and I like country living, where I can go shoot guns in the back yard if I feel like it, and the hand of government lies very lightly upon the people and their wallets. I've been married for almost 30 years and my wife has some mobility issues these days, so clubs and such aren't any kind of a factor. Rural MO Ozark life therefore suits me fine.
I grew up in southern IN, near a big college town; also nice, more densely populated than where I live now and full of annoying Liberals in that particular area thanks to the college; other places I've stayed for enough time to get a feel:
Northern IN - flat and depressing as Hell in Winter.
Western KY/TN - nice, for my tastes. KY has kind of high income taxes, TN doesn't have income tax but does have a pretty bodacious sales tax.
Quad cities area (IA side) - lived up the river a bit from Bettendorf IA; not bad, really, but the wife hated it. Plenty of opportunity to fish in the big river. Cold as a sonofabitch in winter.
Charlottexville VA - Unusually large number of silver-spoon college kids driving expensive cars bought by Mummy or Daddykins, and the kind of town climate that goes with that. Basically what Deb said, but my overall experience was better. Became a rather expensive place to live during the real estate boom, and it's also pretty damn congested.
Southern, NJ - not nearly as bad as everyone thinks. Oppressive gun laws, densely settled (Too much so for my taste), and very burdensome property taxes (But cheap compared to NE Jersey). Not my cup of tea.
Baltimore, MD - Nice place to visit, wouldn't want to live there.
Hinesville/Savannah, GA - Good place for those who like to be able to get out in the country, but within close range of urban amenities too, and coastal life. Hot as a sonofabitch in Summer.
I've been a lot of other places and have impressions of them, those are just the ones where I actually maintained a household over a long period of time.