Searching for an evil unreliable narrator

So I m looking for a book with an unreliable character who is the villain in his own story, but has a charming side and is genuinely funny like Joe Goldberg in the series "You" or Humbert in "Lolita". However, I don't want a book that romanticizes toxic or horrible people, which I know limits my options a lot. Therefore, I ask for your suggestions 🙏

Side note: I like most genres but I don't feel like this would pair well with fantasy or traditional romance.