He is probably much better off at the hospital because they will actually reduce his dose so he becomes more coherent and can benefit from talk therapy to straighten out his thinking. He will be better off conscious and around people,than vegetating and being drugged. Be sure and mention the suicide ideation to the hospital doctor.