You're trading off some pretty hot days for some cold, damp days. I'd probably choose SF in general for the weather and certainly on the scale of the country as a whole, SF is pretty good.
I like SF weather overall, but the Bay Area as a whole generally has fantastic weather. Despite being an SF resident, personally I'd say the peninsula (south of SF) and the most of the East Bay have better weather than SF.
The South Bay and the far East Bay can get a little too hot for my taste, but plenty of people prefer that to year round fog/wind in much of SF.
On the scale of the whole country the entire west coast is "pretty good".
SF is definitely not the best out of the entire coast, and if you consider its cost of living, the weather is trash for the cost. It's notoriously cold and wet for a substantial part of the year.
The South Bay and the far East Bay can get a little too hot for my taste, but plenty of people prefer that to year round fog/wind in much of SF.