Drinking culture has largely changed for the better and I think workplaces are safer than they used to be. But I also think you'd have to be an idiot (or risk-blind) to get loose at company events like a lot of people used to do.
The vast majority of the people at a drink up could handle it, but occasionally there would be the one troublemaker (and it was always the same person, although not always everytime) that simply couldn’t read the room, or couldn’t control themselves.
At official or unofficial drink ups, I’ve seen:
Someone have to have their keys taken away.
Someone have their keys taken away, and then bite — literally, angrily bite — the coworker that took them before running off into the night.
The worst event, I didn’t see happen, but saw the aftermath of. Someone got in a car (hopefully theirs), and proceed to jump the curb of the traffic circle in the office park and ram — and destroy — a nondescript abstract sculpture that was owned by whoever owned the office park.
I believe the last person was fired. Hopefully, that person got help, because that could not have been the first time for a trick like that.
Interestingly enough, all these events happened at the same employer. And yet, I still think fondly of those drink ups (though, not those instances).
We live in a surveillance culture today. And those photos and videos will haunt you wherever and whenever you are in the future.
People getting loose at parties used to mean harassment and it was deemed ok because "men are being men" but it was never ok. Just treat people as they deserve whether you're drinking or not and there's no issue to be had.
I don't think I regret anything I ever did or said while drunk (unless you mean 'taking that last drink that will kill me tomorrow' and in this case, I regret an Irish coffee I knew was too much).