My best friend has spent some time on psych floors of hospitals, after alcohol induced breakdowns. He has found it very helpful, and the staff were always very compassionate. So it does, as you say, help him get back on track.. and sometimes he will stay on track for a year, and then other times much less time..
So it's not a rehab of sorts, it's not really going to treat your alcoholism. It can help you detox and get you stable on the psych end of things, get on the right medications, etc. So then you'd need to get in to whatever type of treatment program might help you. Frequent counselling and periodic reassessment of your medications, for example.