But if you're trying to use it as a euphemism for drug addicts, I think you'll often find that they end up homeless, despite there being SROs, because they spend their SRO rent on drugs instead, and they get evicted. If you're trying to use a euphemism for sex workers, the successful SROs usually had strict rules around the Single Resident part.
Basically it's just like hotels, in the sense that there are both seedy, run-down, crummy hotels and there are upscale hotels. That there are some crummy hotels is not an indictment of hotels in general. If you make the category legal, you will find worse and better examples, and lonely people would have their choice of establishment that would help put them back into close proximity with others.