There is an SRO less than a block from my house (one of very few left in the city). They have strict rules around intoxication outside of your room. It does have the impact of meaning people who can't control their abuse have to find other housing. We should have a place for those folks too, but I'd rather there be a place that doesn't solve all of the housing issues, but can get some people off the streets rather than wait for a solution that solves every issue.
As an aside, they are perfectly good neighbors. As is the studio apartment complex next to it, that is a single tier above the SRO. I have a lot more trouble from the fast food wing place on the other side of the block than I've ever had from my neighbors.