Here's my peace as someone who's lived in all of these areas. I was raised in Atlanta, but since joining the Navy I lived in Rhode Island, Washington State and now I live in the Bay area of California. Plus my sister lives in Boston so I know the Northeast part of the country pretty well.
As much as I love Atlanta, all things being equal I'd rather live in the Bay Area or the Northeast. The Hard Sell for most people is the cost of living and high taxes. Perfect example, I live in the suburbs of the East Bay in California (Walnut Creek) and I pay $3,000 a month for rent. Fortunately, I'm in the military so they pay for my housing but otherwise there's no way I could live in this area especially when you put the crazy California taxes on top of that. If I ever want to buy a home I can not live here that's why many people are leaving California, it's not because they don't like it it's because it's a prohibitive Lee expensive to live here.
If you have the money, by all means live in Boston, New York, or LA. For most people you just get more bang for your buck living in Atlanta. Nice weather, a lot to do, beautiful women for half the price of those other places.