SF's spending in 2019 was 12b dollars (roughly $12,000 per resident).
Of that, 1.6b went to MTA ($1600 per resident, or 13% of total spending) and 360m went to addressing homelessness ($360 per resident, or 3% of total spending)
Comparatively, SF's GDP was 500b (500,000 per resident).
To conclude that we're spending all our money on this and getting no results seems wrong when we're spending so little of our budget, and our budget is so little comparatively to the economic activity.
*(these numbers are from http://openbook.sfgov.org/portalpagehelp.html#sfopenbook 2019 spending)