Like everyone else said, it really depends on the hospital.
My very first one was terrifying. They'd lock you shut in your rooms at night, the bathrooms were filthy, etc. When I left they told me I didn't belong there and that if I opened up about my ideation again, I'd be there for months longer.
I ended up at a different hospital later and it's an amazing place. A huge campus in the woods, with different cabins; it felt like a getaway. Food was great, staff was great, they had a buffet. I also met some really amazing people there, and it helped me during my worst times. I would make up excuses just to go back.
It takes a lot to check yourself in, so it's really big of you to consider it. If you feel like it'll help, I would try it out.