My best "I was drunk story" is probably this one.

About 10 years ago I was in Florida on business.
I closed a big deal early for the company I was working for at the time.
I had two days to kill and there was a karaoke bar next to the hotel I was staying at.
Anyhow, went over there to celebrate with a few cocktails and wound up closing the place down at 2AM doing shots with the locals.
Made it back to my hotel fine and crashed out (my hotel room was on the second floor).

At about 4AM I woke up and had to go to the bathroom.
I got up and walked into the bathroom and the door shut behind me.
I then realized I was in the hallway of the hotel butt naked with my junk in my hand, drunk as hell with no way of getting back in my room.
I had walked out of my hotel room thinking it was the bathroom door (oops).
Talk about going from dazed and confused to coherent in about 2 seconds.

Anyhow, I walked down the hall and got on the elevator to go to the lobby to see if I could get a new key.
The entire time I was thinking to myself "please don't run into anybody".
Walked right up to the front desk covering my junk with my hands and told the girl that I locked myself out of my room.
She asked me what room number and handed me a key.
No questions asked.
I wonder if this sort of thing happens from time to time in the hotel industry.

Oddly enough while walking back to the room there were vending machines and I was kind of hungry.
I took a quick peek and then headed back to my room to grab my pants and walled.

This could have ended way worse than it did LOL.