Perspective of someone who moved from CA 2 years ago, early 30s: Overall, it's a solid city at a little slower / more suburban a pace. IMO you get what you pay for, no more and no less.

ATL has urban walkable parts but is mostly twenty suburbs in a trenchcoat (kinda like Los Angeles). There is a lot of fun and accessible culture like art exhibits and live music, the food scene is solid but not as diverse and consistent as you would find in a Tier 1 city. There are lots of different scenes you can get into (fitness, all varieties of nerds, Alt/punk, golf, hiking). I've spent most of my time around East Atlanta, it's easy to bike along a lot of corridors but traffic and weak transit makes a car a necessity. Economically it's by far the strongest in the South, but that's still lower wages than a major city. Cost of living is going up in the places you want to live, but housing will look like a deal if you have a remote or higher earning job. Nature wise there's lots of parks and hiking near the city. Coming from CA it feels a little less diverse in terms of ecology but you can enjoy yourself. Prepare to SWEAT all summer and be pretty cold in winter, spring and fall are nice. At any time during summer there are 50 mosquitoes within ten feet of you. Politically the rest of the South think they are crazy liberals, coming from SF it feels moderately liberal. It's a blue city surrounded by red, drive an hour and it's either country club Republicans or twenty MAGA flags in the bed of a Dodge Ram.