As you've proven, having alcohol based events doesn't require anyone (and def not everyone) to get drunk.
> It's hard to work with someone who threw up in your Uber the night before
You clearly have some issues with people who drink to excess. That's your prerogative, so maybe you should work with different people.
Wtf? That's definitely not on the poster. I don't have a problem with an (optional) work happy hour, but its still work and a base level of professionalism is expected. People drinking to excess at work events is a major red flag for the company.
One of the nice things about remote-friendly companies these days is less pressure to be around alcohol-infused events.
I have no use for one. Haven't opened a bottle in a few years now. And maybe have done so at most 30 times throughout my life. (Don't drink soda and rarely drink alcohol.)