A lot of the housing issues would go away if people in the Bay Area (ie. my neighbors) didn't vote down every single thing that would allow more than a single family home. I'm ok with my home price being cut in 1/2 if it means more middle class people can move in. Most of my neighbors aren't.
There is a "missing middle" of housing throughout the entire Bay Area of 4-8 unit apartment buildings near transit.
SB827, flawed as it is, is trying to fix this. If it passes, SF basically won't be able to block construction anymore, regardless of what the residents want. If it passes you'll see a lot of eight story buildings replacing single family homes.