I grewup in the bay area (peninsula) and was in SF a lot. It definitely rained a hell of a lot more. The weather now is practically like what people used to think of as Santa Monica weather half the year (or maybe Santa Barbara)
They say SF will be San Diego in 50 years, so perhaps still liveable.
SF does pour rain fairly often between January and March, those films could have chosen the time of year for the desired atmosphere.
Not anymore. It used too every year, hardly ever now.