You may find that your preferences change as a result of having children. Also - there are a lot of different living options falling somewhere between San Francisco and Atlanta suburbs with regards to population density. E.g. a small city with a walkable downtown, restaurants, etc., but affordable enough to own a decent-size house and a car.
I spent a lot of time exploring with my friends, and being independent. I think it would be hard to have this kind of experience in a rural town, but in a suburb, it seems pretty normal.
This is interesting. I live in a suburb and my suburb along with many of those neighboring all have good restaurants, farmer's markets and good coffee. I will admit that we don't have many museums, but the city is only a 20 minute drive if you want to do that.
I will say that we have a plethora of nice parks and a great library system. I've noticed that they are all cleaner and better maintained than that of the city too.
Interestingly, the suburban are I live in now if in the middle of a lower income neighborhood and a typical middle-class southern suburb. There is slight walkability, but only towards the poorer area, the sidewalk abruptly ends heading the other way
Suburbs sort of combine the worst aspects of city and rural life; too many people around that you don't really get space, privacy, or scenery, yet not enough people for there to be any interesting restaurants, farmer's markets, museums, coffee shops, or really just anything to do.
I love the Bay Area because it offers all the amenities of a big city, yet all sorts of natural beauty is within an hour's drive away. One of my relatives visited recently and was shocked at how you can be in downtown SF one minute and then standing in an old-growth forest of redwood trees twenty minutes later.
Unfortunately, I imagine once my wife and I have children, expenses will become rather difficult. I'm not sure how well a tiny apartment will accommodate a growing family, especially if we have two or three kids. So... I'll probably end up back in the suburbs eventually, but I'm not in a hurry, and it certainly isn't my preference to be there.