I live in Atlanta. I rarely go outside the perimeter as we call it (Outside of I-285 which is the beltway interstate that circles the city). The city is very liberal (as is all of my social circle), majority black, very LBGT friendly (huge Pride parade, Rainbow crosswalk on a major intersection in midtown, lots of gay bars/clubs and so on). So in short, you don't really fell it here other than being pissed at election results and terrible state legislation like Campus Carry. I do worry about religious liberty bills a bit now. Governor Deal vetoed it even as a Republican for fears of losing business. Kemp would probably do the same, but I don't feel nearly as confident in that with him as I did with Deal who was pretty moderate for a southern Republican Governor. But it's still unlikely as Republicans don't want to lose the Hollywood/TV business, events like the Super Bowl etc.
Otherwise, what really affects your day to day life are decisions of city and county government. And there are no republicans there. It's super rare to even see one on the ballot at general election as it's usually just the Democrat who won the primary running unopposed. They don't even do a partisan primary for Atlanta mayor as republicans have no chance. It's just a first round election that usually always ends up in a runoff between the top two.
Also, even living in a blue state people are still largely ignorant conservatives outside of the metro areas (look how red California is in the vast rural stretches outside of SoCal and the Bay Area). So you stlil have the "blue bubble" phenomenon most everywhere, just less shitty state laws and policies than in red states.
Of course I also say that from extreme privilege as a straight, white male with a decent income. I'm sure it's much harder on others. My black and gay friends feel more or less the same as I do, but they are all also upper middle class types so I don't have a local frame of reference for how lower income people feel about being in a blue bubble in a red wasteland.