As a consolation, I must say that e.g. NYC was also handled miserably, say, in 1980s. Despite that, it rose from the filth, and is now fine, even outright enjoyable here and there.

I think that SF will also shake off its current insanity, and will turn back into a flourishing, living, and thus changing city.

It takes time, thoughtful voting (of many, many people), and likely a bit of luck.