I don't think suburbs are the end of the world, especially for people with kids.
You also left out college towns, which can be very nice. While the college town I'm living in now (Laramie, WY) doesn't have the sheer diversity of a major cosmopolitan city, it attracts a healthy selection of smart, interesting people. I can also walk to work in 10 minutes, housing is way cheaper than places like Seattle and SF, and there are mountains less than half an hour away. If you don't need the networking resources of a major city, a college town can be a sweet deal.