All of my in-patient detoxes have been great. You have no rules to abide by. You can sleep, watch TV, read, chat with other detoxers. It's not bad at all.
You'll probably be given Librium 4 times a day for the first 3 days, then weened off over the next 2-3 days. They give you Trazodone to help you sleep. They also give you plenty of vitamins and minerals to help your body start to heal.
Your vitals will be taken every 4 hours at a minimum.
Do it! It's not bad at all. If anything, it's just boring.
Trust me, getting sober (detoxing) is a heck of a lot easier than staying sober.
/rhn