It would be a significant benefit to the people of SF if the western half of the city were significantly upzoned with a lot of new housing construction here and throughout the Bay Area, and ideally rent and house prices cut by something like half (gradually rather than in a market crash), so that more of the people necessary to run the city could afford to live here.
I’ve long pointed out to conversation mates IRL that for a technological civilization like ours, shelter costs are a straight deadweight, Tsiolkovsky rocket equation cost upon the innovation throughput that is the civilization’s lifeblood. In the U.S., healthcare pricing policies are as well, but that’s a different conversation. Both are stranded capital that need unlocking towards increasing the technological development pace.
But most people with mortgages are trapped like a monkey’s fist around a fruit in a jar, by the siren song of house appreciation.
I’d rather have fusion, life extension, solar system colonization, mind uploads and AGI sooner than be “rich” in real estate.
If you believe otherwise, you will learn the hard way when you seek your reforms and find that none of the people spouting the high-minded capitalist rhetoric support the actions that would bring it closer to reality. In short, the monkey's hand isn't trapped. The monkey is masturbating into the jar. It knows exactly what it is doing and you will not be thanked for interrupting.
If by "great" you mean "where the jobs are" then I agree.
That has been the primary driving force behind urbanization since at least the industrial era.
End result: cities have more fine-grained amenities. People who want more amenities live in cities.
The city is convenient and fun: it provides easier transportation, more amenities, more other people to engage with, more companies of all types to do business with, etc.