Honestly - in my experience, they are not. I didn't know anything about SF before I moved there. No one around me in the South ever talked about it. Now that I go back home and I mention I lived in SF I may hear people say something along the lines of "wow they are really liberal out there aren't they?". Nothing along the lines of the vitriol I hear in the Bay Area.