The one thing that bothered me most about the bay area was all the people who were more willing to live in cold, foggy, crowded, expensive SF AND deal with a commute to the area with nicer weather (south). Maybe they had family issues back home and have a need to live somewhere that is more "open minded" than anywhere else.
SF weather is neighborhood by neighborhood, with cold and foggy being ubiquitous only in the summer time, which is counterintuitive for tourists. It's anywhere from 58 to 72 degrees almost all times in parts of the city. Nice weather if you know where to look or have a particular preference.
So maybe thats just a secret for you?
But I do like areas that are warm at night time too, which SF is not.