Sure, but most of the people SF / Oakland don't live in Sunset. Saying that SF's weather is dismal just isn't true for the majority who live and work here. Which isn't to say that everyone experiences glorious weather daily, to be sure, but it's pretty nice for most people.
You can get a better picture of this on http://fog.today which has a tool showing historic cloud cover including the marine layer.