In a similar vein Walter from breaking bad, though that makes less sense. Tony soprano was at least a charismatic sociopath, Walt was just an asshole
Also the classic nerd version, Rick from Rick and Morty. Bojack horseman too, which is extra funny because the show eventually called this out (in a way that almost certainly went over the head of some of the people who idealized him)