I feel hopeless that this will ever change. In a extremely liberal city like San Francisco, where nearly every citizen follows progressive politics, NIMBYs have passed laws the enrich wealthy renters and make it hard for the poor to afford to live in the city.
If San Francisco cannot get this right, no one can.
From an outsider perspective San Francisco strikes me as a culture that is, and has been for decades, a creation of the affluent class.
Hippies and tech founders alike have all talked a good game about an equal society, but both groups are primarily seeded from the children of the rich and well educated and have worked to preserve the status quo.
New York City, for all its superficial associations with finance and Wall Street culture, has always seemed to be a much more genuinely diverse and empathetic place in actual day to day policy and practice.
https://en.wikipedia.org/wiki/California_%C3%9Cber_Alles
for appropriate relevancy nearly 40 years later.