Let me put it in terms that Gene Roddenberry would have explained. He emphasized it in his work. You might have heard about it. Star Trek. "The needs of the many, out way the needs of a few, or the one."
When you're more interested in the humanity, and dignity of those afflicted (the few) than those not afflicted (the many) then you're going to continue to generate more afflicted. You have to stop the problem at the source.
That means: Cutting off the drug supply. Enforcing laws. Everything you most likely despise. You only care about those that are on those streets.
You have to make it harder to become homeless, than it is to be a successful functioning member of society.
Jobs are not the problem. There are jobs everywhere. In one of my businesses, I needed truck drivers. I can't find them because hardly anyone can pass a drug test. I will pay for them to get their CDL, if they're drug free. It's not happening. I sponsored 3 people from India to drive trucks for me. They work 6 hour days, make $35 an hour, with route bonuses, and benefits.
I have a software company (or had), where we did DoD projects. It is next to impossible to find anyone that can pass a background check for a security clearance with the FBI. Why? Drugs.
I had another software company that was in the Casino Gaming space. It was difficult to get people licensed. Why? Drugs.
There is opportunity for everyone, bad decisions put you in the street. Then people like you and I have coddled these people, and give them enough to get by, so they don't want to return to being a functioning members of society. Anything else, they steal or commit another crime to get more drugs.
I have spoken to many of these people. Your presumption shows your character. I have donated more money to this problem than you will make in your life. Money is not fixing the issue. I have stopped supporting many alcoves. We keep creating more, and more that end up needing help. The majority of the problem revolves around drugs.
Drugs cause mental issues. This is a fact. People don't want to work. They want drugs.
So, I will not be returning to SF. I will not fund the business I was there to invest in. Keep going with your idealism. The universes own laws will eventually catch up with you, as history shows us every time.