I don’t know if video games count, but the detective in Disco Elysium is a fresh take as the story starts with him being dead from drinking for 2 days in the middle of the murder mystery, hated by everyone in town and having an underling with a decent lifestyle sent to cover up for his massive mistakes. You play as him and you still solve the case, but honestly, you keep finding out all the ways you messed up your own investigation when you were drunk and drinking in-game will mostly make you fuck up even more. I loved the game and I thought that was written by someone who does know a real life alcoholic