I've never actually been drunk myself, personally I enjoy being the guy that out-drinks people and still remains sober :D. However I've been involved in some pretty funny drunk stories.
One time in high school I was at a friends 18th birthday party. We were at a bonfire in the woods behind her house and I walked off to grab some more wood for the fire. Everybody was sober when I left since they hadn't touched their drinks yet, but in the few minutes it took me to get back everyone managed to get wasted. It was kind of annoying having to keep everyone out of the fire, but it was hilarious watching two people crawl on all fours and bark at each other like dogs while fighting over a slice of pizza... like dogs... They literally grabbed at the slice with their mouths and barked and growled at each other. It was bizarre but funny at the same time
Another story was when I visited a friend who was attending a different college. On night one we did some drinking games with his roommates, and another guy from our high school class that showed up (I'll call him C), and he was the first to succumb to the alcoholic powers. He randomly walked into his room and passed out, so his roommates and I decide to TP his room. We go into his room and starting throwing paper around while C "sneaks" in, turning off the light and crouching behind a chair next to my friend's bed with a loaded can of silly string. The man was at least 6 ft tall and weighed at least 200lbs. Stealth was not an option for C. At some point during the slinging of toilet paper, my friend half-woke up and vomited on his bed causing C to army run out. Moments later my friend decided to play with his mess and then got up and started running after us. He chased people all over the house and into the yard before falling on his face and passing out again. My friend didn't really want to clean his mattress the next morning so we just lit it on fire in his backyard (my idea). On night two we got bored and started raiding frat houses. C was the only drunk person at this point and decided to let everyone know that he was a marine. He hadn't even attended basic training yet. Every room we passed C would check their fridge for beer. At one point he just walked in while a couple was watching TV. He walked past them, pulled beer at their fridge and stared them dead in the eye before saying "I'm a marine" and then leaving. We also stole a mattress from one of the frat houses for my friend.
The final, probably best story, was finding out that an old friend of mine decides to mow the yard when he's drunk. Whether it's his yard or not. Once again I was at a friend's house, we'll call him friend F, and walked away for a few minutes only to come back to someone completely wasted despite not having drank anything before I left. Apparently a different guy decided to chug an entire bottle of malibu. A few minutes later that same guy turned into a fountain that almost reached the ceiling. We ship him off to another part of the house to clean up while the rest of us clean the living room. We had to throw F's dad's favorite chair out on the lawn thanks to fountain man. After that ordeal the party goes on and more people get drunk resulting in mower man getting blackout drunk. He goes crazy and it takes a bit to get him settled down, thankfully by this point fountain man has sobered up a little and is able to aid in restraining the beast. Finally things are calm and nobody's doing anything stupid. Until I, being the natural klutz I am, flip over a table as I stand up from the couch. Despite being sober I may have caused the most destruction lol. Glasses shatter and drinks spill as mower man quietly exclaims "Oh no, we're in trouble" and drops to all fours and crawls away as me, F, and fountain man clean up my mess. We clean things up and begin to wonder where the final guy went when all of a sudden we hear F's lawn mower start. We look out the window to see mower man start gliding out of F's shed and into the misty night. F tackled mower man off the mower and pinned him down with the help of fountain man. We eventually dragged him inside where he finally passed out.