It actually seems plausible that SF might have the worst homeless problem as a direct result of actually doing the most to help the homeless.
SF literally gets punished, the better job they do.
As they provide services, the city only attracts and retains a bigger and bigger population who become accustomed to relying on just enough services to continue living on the streets.
San Francisco is creating its own problem here due to its own altruism.