So I think your observations can be broadly true and also that if you caught the people who are chronically homeless as they were falling out of being homed they would seem way less insane and their problems would be far more tractable
They invested a lot of money which is good and all of the programs they put it into seem like they will help, but I think their zoning reforms wern't strong enough to truely increase supply enough
There is some evidence that increasing minimum wage increases the prices of goods for minimum wage workers so that their rising wages don't actually give them more buying power, also we can just not make it illegal to build new housing in places where there is already housing but ymmv.
I don't think this is super true, I think people become the random guy yelling at trees rather than some guy who works at the Duane Reade because homelessness causes you to go insane
Some states (montana Minnisota although the later is less likely to succeed imo) have started doing this at a state wide level, I think Cali has a particularly uphill battle since the housing situation is already bad and the headwind that we really will never be able to change: prop-13. (I think all the other things that are preventing new housing CEQA, SFZ poor public infrastructure can all be changed if we do it right but I don't see prop-13 ever changing even if we get these taken care of)
Other people have linked good articles, but a good way to think about it is in Japan and West Virginia they have almost no homelessness and in both those places its very easy to rent a studio for under 300$ a month. Even for someone addicted to drugs you can see how its possible to manage 300$ a month (or for say a charity or city organization to come up with the money) without solving the underlying issues.
You don't understand Nevermind wasn't actually all that good Bandwagonesque BY Teenage Fanclub was actually better and more instrumental into turning the early 90s into an audio experience.