How about using zoning laws to enforce the mixture of types of home AND the amount of housing ratio to the number of jobs (commercial and industrial zoning)?
If you have more jobs than you have homes, don't zone for more jobs.
If you have more jobs than you have homes, don't zone for more jobs.
But my main point is, it takes interventions that intentionally constrain the way the market works, to get a fair system going. To institute a sane proportion of housing to jobs nowadays that preserves a mix of affordable and luxury housing, you're going to need to do a hell of a lot of subsidizing to make that affordable housing worth it to construct in the first place. So who's up for subsidizing it?
If a city does not want to add much density, I am fine with that as long as they are not allowed to keep adding jobs.
160,000 more people work in San Francisco than work there.