It really depends on a lot of different things, whether you'll have an OK experience in hospital or not. Some people look at it as a "rest" and are happy to sit around doing nothing all day. If that's what you want, it might be OK. I didn't find much in the way of help in them though. Some at least attempt to help with regular group meeting sesssions, art therapy and the like but I had some damaging experiences in those things too. (Like the time a therapy group was told 2 people would have to leave and it was up to the group to decide who those 2 people would be...now discuss it for the next hour. I knew immediately they were playing a sick game known as "lifeboat" in which a group of people are told to pretend they're on a lifeboat, and two people must get out. I played along anyway, knowing they would never let the group decide something like that. Several people got so upset about the whole thing they ran out crying. I got voted out for "being too healthy." (Which shows how ridiculous it was. I'd just almost died of a suicide attempt and the group members didn't know that.) At the end of the session, the leaders say, ha,ha , just kidding, sort of thing. Sick. So sick. Sometimes got the impression the staff was a nuts as the patients and making them crazier by the minute. There were other things too, but too long to get into. On the other hand, in that same hospital, I met the pdoc who would help me and support me for the next 14 years.
Another time, I was at the Center for Addiction and Mental Health in Toronto getting Cognitive Behavioral Therapy as an outpatient. It was excellent and I admired and respected everybody in the Mood Disorders Clinic. They hospitalized me for suicidality and I figured hey, this is the most highly respected Psych facility in the country, so how bad could it be? The inpatient experience was awful. There was no treatment other than seeing the inpatient pdoc every few days. The nurses never even spoke to me. No group therapy, nothing. I just started denying suicidality and acting as healthy as possible until they let me go. On the other hand, I made a good friend there amongst the other patients and we stayed friends for many years. On the other hand again, he killed himself eventually.
Anyway, those are just a few of my experiences. Sometimes you're lucky and you meet good people in the staff or patient population and sometimes you're not so lucky. Sometimes the funding is better for programs in some places than others; sometimes the programs are good, sometimes not. It's a crap shoot.