People act like it is, the reality is different. Why do people all need to live in SF?
Serious question, why?
There are small towns throughout the country within 30-45 min of a major city. If you want to go further out, you can find small towns / cities everywhere. I'm currently living a fair distance from any major city and can still get literally anything I can imagine delivered. It's cheaper, taxes are cheaper, food is cheaper, fuel is cheaper, I have more land, I can see trees / stars. Yet within a brief drive I can be in the center of a major city with all it entails.
San Francisco is fairly dystopian. I used to live there, walking over human waste, people getting head in the street. Naked women rolling around after a bender, a persons leg rotting off. This was my daily walk through SF to work. Now, I see cows, sit in the grass and still make more money and am away from the tragedy.
I think most people think building more buildings would solve the homeless problem. The reality is that dispersing production would save the city. I.e. limiting growth and having strict policing. The homeless would leave / be swept up and arrested. The housing would be expensive, but wealthy people would still live there. Then Sacramento, San Diego, Colorado, Texas, etc. is where people would move. This would help wealth inequality (spreading the wealth) and improve mental / societal health.