I know this is probably a common topic. For me, I’m not sure if it’s a “trope” or just totally misinformed writing, but it’s how many authors approach alcoholism. Some examples are Girl on the Train and The House Across the Lake, among HUNDREDS. If anyone else here has struggled with alcoholism, you know it’s not just "i woke up after downing an entire bottle of whiskey but was able to shower, down a cup of coffee, and solve a murder. "
Those types of characters actually work great as villains, so long as the writer commits. T-1000 from Terminator 2, The Judge from Blood Meridian, Baron Harkonnen from Dune…
The real trope is when they suddenly develop empathy at their defeat. That’s what devalues the entire character imo.