SF isn't the Bay Area. Traditionally SF wasn't considered part of Silicon Valley at all (these days depends who you talk to and when and where they got immersed here).
> I've lived in a number of different places in the country and the Bay Area is hands down the worst
I somewhat don't actually like the Bay Area TBH. Every few years I look into leaving. I go through all possible options and their pros and cons and, depressingly, every time I find that Silicon Valley is still the best place in the US.
It's not any one thing, but I have not found any place that is either ok or reasonably good about everything without having any terrible deal-breakers.