I found this thread after having a string of mysterious deaths in my fortress where I've had five visitors and three dwarves mysteriously drop dead in the past year. I don't even realize the visitors die until I see a new body in the corpse pile outside, and when a dwarf dies I get the announcement that they were just suddenly found dead.
I ended up using Legends mode to see that they all died of suffocation, which I then learned is actually alcohol poisoning.
My hospital is ten squares down the hallway from the tavern, and I've never seen an individual taken there after drinking themselves unconscious. The most recent death, my hunter died in the library with four other dwarves in there reading and leaving him to die instead of taking him to the hospital.
In a game where losing is fun, I still feel like this is a pretty irritating mechanic because it's not intuitive. You're trained that your dwarves need alcohol, you can't control how much they drink of it, and then your workforce starts offing themselves because you're letting them do what you've been trained to.
Your fortress getting rekt by a mega beast that stopped in for lunch is fun. Your fortress getting flooded because you mismanaged a floodgate is fun. Your population slowly, mysteriously, declining because a game feature (tavern) doesn't work the way you'd expect and you can't figure out why without save scrubbing and checking legends mode is not fun.