I'm sorry that you're going though this right now and I hope you feel better soon. But it is very good that you do want to help yourself and that you are reaching out and considering going to a hospital.
I was hospitalized once back in March for 8 days. I didn't choose to go (my parents forced me into the cab and took me to the ER because I had a complete mental breakdown) and I was just waiting in triage for a while after I got a mental health evaluation and they figured that I needed to go inpatient. I had to spend the night in the hospital so that they could find me a bed in a psychiatric hospital (because the hospital I went to didn't have room on their psych ward). The next morning I was sent by ambulance to the inpatient facility and I actually had a very positive experience there. Although I went to one of the nicer psych hospitals I later found out. I wasn't locked up in a room or restrained or anything like that (but if I ever threatened to harm myself or someone else I would have been restrained).
The people there were overall very nice, although some of the staff were rude. We had a lot of group therapy and there was a common area where we could watch TV at certain times and play card games and stuff. The food wasn't too great, the beds weren't too comfortable, and the shower water was pretty cold, but overall it wasn't bad. I mean, it was a hospital, not a hotel. :P
I am grateful I had a positive experience there and I got my medications adjusted and received the help I needed. And in a lot of cases when you leave you won't just go outpatient; they'll step you down to a partial hospitalization or an IOP which helps a lot. I hope everything works out for you and that you do not need to go to the hospital...but if you do I hope you have a good experience.