SF weather is unusually consistent and most days it's on the cooler side but not super cold, often a bit cloudy/overcast. If you like that (I do), the weather is great. If not, the weather will be bad almost every day.

I haven't been there either but weather is clearly a very subjective thing. Personally, I don't like rains at all, for example, but most others seem to enjoy them (at least here in India). So, it depends.

coming from western washington, it felt amazing!!! But yeah, coming from other places I think it feels too cloudy/foggy/cool for people.