Yep, I've done the album cover filled with shaving cream prank, it does make a mess, also did a variation of that, the shaving cream can grenades. Take a shaving cream can and put a couple pieces of duct tape on one side, right when you open the door, cinch the tape across the button and then lob it in the room.
In college, drinking to excess was basically a hobby and one night several of us had gone out partying after drinking most of the day. One of our buddies had puked all over the bar, it was a nasty mess and we all get kicked out and literally have to carry him out of the bar. We get to the dorms and have to carry him up to his room, no elevators, to the 4th floor, he ends up puking again on the way up. We finally get him to his room and in his bed and we schemed on how to pay him back. We decide we're gonna carry him and his bed down to the laundry room on the 3rd floor. We pick up his bed with him in it, we have to roll him off his bed a couple times to get through the doorways, but we carry him and his bed to the 3rd floor laundry room. When we finally get him to the laundry room, he starts puking again and we have to roll him over on his belly and head hanging over the side so he doesn't drown himself. We strapped him down to the bed so he can't roll over and left him there. He woke late that next morning with a crowd of people around and one of the RA's literally poking him with a stick, to stay clear of the 'splash zone'.
We only did that prank a couple of times, under special circumstances.