Bay Area is big and micro climates can vary!
We lived in the Sunset district which was manageable but later moved to Mill Valley and the summers were _very_ brutal, to me. A couple other office mates lived in San Rafael and I distinctly remember everyone complaining about the heat and sweating.
We all eventually bought air conditioners for our bedrooms just so we could sleep comfortably at night.
But brutal is all a relative term. Someone growing up in the south with no access to AC would not call it brutal while I and my other office mates who were used to AC were "dying" without it