That seems like an unfair metric. Any program that helps homeless people significantly more than anywhere else in the USA is going to become the new capital of homeless people and their population will explode. It doesn't mean the people helped are worse off.
Right, but the taxpayers in that city are worse off. That's why any solutions need to be driven at least at the county level and preferably at the state level. Leaving it to individual cities creates all sorts of perverse incentives. (SF is somewhat unique in that they are their own county so for that area specifically, shifting programs from the city to county level wouldn't change anything.)
Taxpayers are pretty much always going to be worse off helping the homeless. Only a small fraction of the chronically homeless will become tax positive citizens in their lifetime.
Either you start off with the first principle that it's OK for wealth-transfer schemes to make tax payers 'worse off' via compelled charity, or I don't think you can get to the point of supporting generalized homeless relief programs. Maybe programs targeted at short-duration stuff to get people into jobs that are capable of doing them and a housing contract might work, but it'd have to be extremely well thought out and wouldn't benefit most chronic homeless.
My point is that it's a lot easier to share the tax burden at the state level rather than in individual cities.
I mean, San Francisco could spend that money housing their homeless in random cities spread around the country - investing in these cities and avoiding encouraging influx to a single spot... Possibly even cities with jobs, and funding corresponding service and construction jobs in these cities. Except of course for the NIMBY problem - I laugh at how that would be received in the cities I know about.