But this problem is eminently fixable with political courage. People with jobs need a place to go home to sleep at night.
The political courage needed isn’t there. Because the state is liberal, and the Bay Area is a very liberal area in a liberal state. To the extent that government, or political issues, are a cause of housing prices being high, that right there ensures that there will be no solutions. Exclusionary zoning is a big problem. That will not be changed by existing liberal zoning officials.
Play stupid games, win stupid prizes.