Welcome to BAR!
I moved to the bay area about 3.5 years ago. The choice of places to live also depends on your age, whether or not you want walking/easy access to amenities/restaurants/bars, if you have young kids etc.
In terms of fog, I have solar on my house and to be honest, even thick fog...