I've long thought that we need to get back into the business of having mental institutions, for many of the same reasons you listed. There are people that are persistently mentally ill, and no amount of social programs are going to help them because they are utterly incapable of properly taking care of themselves. They need support and supervision, and having some bread line where they can go an get a meal or a free clinic where they can go and get their meds (that they either don't take or sell off for money so they can go get their own drug of choice) doesn't cut it.

The other two examples you listed are just more instances of mental issues. Dude is a sex pest and won't stop doing lewd things in public? That's not being a piece of shit, that's a mental health problem. Drug abusers and addicts are the same thing, if it's progressed into a psychological dependency. Jimmy doesn't need to go down to the methadone clinic on the regular, he needs inpatient care to detox from the heroin and then he needs psych help to get over the issues that drove him to that point.

The long and the short of it is that the state of mental health care in this country is abysmal. I'm not saying that we need to go back to the days of Nurse Ratched and abusing mental health patients just so the doctors can see if some novel treatment has any effect. I'm saying that we need places where the people who need help and treatment can go to be housed for long-term (and even potentially permanent) situations and receive modern health care.