One small correction, which is that the housing crisis in SF is a function of the region's housing policies, not just the city's failures. Some of the governance problems here are just structural, that there's no one with authority to tell Palo Alto that they can't be a leafy suburb anymore and need to build high-rises.
It seems to me the biggest reason people are leaving San Francisco seems to be the rent is too damn high which is a pretty straightforward effect of the city's housing policies.
I think it's pretty clear that the Republicans party doesn't have a monopoly on poorly run government at the city and state level. (At the federal level there does seem to be a large gap in the ability to govern between parties.)