In general the Bay Area is the best overall microclimate in the US. I have lived in Boston metro, Chicago metro, and now the Bay Area. The Bay Area provides a very gentle, four-season, mediterranian-like climate, with minimal frosts. Generally, communities that face the ocean, (San Francisco County, San Mateo County, and Marin County) have the marine layer to contend with. This creates fog in the summer and fall months. The East Bay (Berkeley, Oakland) also have the same issue. So, you can have stunning views of the Bay and the Golden Gate from say, Albany, and be socked in with lots of fog. This depresses some people. On the other side of the Grizzly Peak Ridgeline is the Diablo Valley. (Mt Diablo is the highest peak in the Bay Area), and it is a hot dry microclimate. For my money, the best microclimate in the Bay Area is Martinez, in the shadow of Mt. Diablo. One has the benefit of being outside the effects of the Marine Layer, you have very frequent sunny days with full sunshine, but due to being on the Carquinez Straits of the Delta, you have the cool air from the Delta coming into Alhambra Valley during the nights. An added benefit is low humidity and no mosquitos. Also, Martinez has no fault zone running through it, so is statistically more stable with low land liquifaction risk.