I don't do it often and wouldn't choose to do it for a long holiday but for the odd weekend away it makes arrangements easy and saves money.
I usually pack PJs to sleep in although I don't use them at home, but I get so hot at night, especially in a hotel room. Would vest and (boy short) knickers be acceptable? The person I'm sharing with is a fairly good friend but we've never shared a room before.