There was a lot of panic when the city supervisors started tweaking the required percentage of below market rate (BMR) housing, and even suggested they might no longer allow the fee payment mechanism (instead of having 20% of units as BMR, contribute a similar dollar amount to an affordable housing fund). I personally think the microhousing projects (funded by those payments) have the most promise, but I worry that it's a repeat of The Projects from the 50s and 60s.
Urban planning is a proper field of academic study with scholarly journals, university departments, doctoral programs, etc. MIT has a department awarding PHDs to people trying to tackle that problem.
So there isn't some simple bold brash bumper sticker sized solution here and thinking there is is part of the problem.
Regardless, as long as the pace of housing development is held below the pace of job growth and migration, the region will continue to get less and less affordable for everyone.