You can never build enough housing in a high-demand city without destroying the city; the demand is too elastic, the incentives between neighborhoods/culture and developers too misaligned.
San Francisco's problem is in the externalities levied by the immature VC-valley monoculture; significant increases in market rate housing density bring corresponding increases in the societal/cultural problems underlying this issue.