I have had a wide range of experiences with inpatient psychiatric hospitalizations. I can only speak for myself, but on the whole I have only found it helpful when I am at a point where I am spending most of my energy keeping myself safe/keeping myself from suicide, or when I am not able to function in a basic way (eat, sleep, go to work or school, go to therapy). There is not a lot of "therapy" in the hospital, it is more focused on safety, medication, and teaching coping strategies. For me, it is also hard to make the transition back to outpatient - there is 24/7 support and caregiving in the hospital, and it is very structured. It has always been hard for me to go back to my own life, creating my own structure, and my own support.
Hang in there, I hope that helps.