"When the options ar homelessness or subsidized housing, subsidized housing is absolutely the best option, which is backed up by decades of data."

Not quite. That's only true if you are housing people who ended up homeless due to bankruptcy or similar reasons (lost jobs, medical issues, etc). If you have people who are homeless due to sever addiction, you just end up with more OD deaths. You have similar issues with people with sever mental illness.

The homeless are not a monolith and different parts of the population need different solution unless you really really don't give a f*ck about them.