How effectively is that money spent?
My cynical assumption would be that most of the money goes into employing political allies of the city of San Francisco.
https://www.nytimes.com/2021/10/04/nyregion/the-homeless-she...
More or less, yes. See my other comment on the city's homeless-industrial complex.