We see the results: https://seliger.com/2022/06/29/homelessness-is-a-housing-pro...
Newsom is one of my least favorite politicians, but credit where credit is due this is one of the best things that has been accomplished under his administration.
No amount of housing will help those doing drugs and defecating on the streets. They need mandatory treatment if they are public nuisance (which they absolutely are).
For people "out of luck" but willing to get on their feet there should be socialized housing, not necessarily in SF (since that area is super expensive).
To deal with that, you need medical facilities. Mere housing is insufficient.
rather then, expensive housing made it impossible to keep house for more and more people with issues.