I am from the American south. The friendliness is almost entirely superficial. Let these people find out you're gay, or liberal, or not a churchgoer ... you'll generally encounter a completely different experience.
People may not talk to you about politics anymore, but anything else - work, kids, cars - is a fair game.
At any rate, I live in the bay area now and I very rarely encounter issues with un-friendliness in the contexts mentioned in this thread. The lack of effusive friendliness that I do encounter for the most part is cultural. Which makes sense, as the bay area is extremely diverse culturally.