Some D&D adventures allow players to be villains, like Tomb of Horrors, Curse of Strahd, and Out of the Abyss. Curse of Strahd includes the option to play as a Dhampir or party member double-crossing ...
Adventures in Faerûn has 51 adventures, and it's not really a surprise that some end up being a lot more fun than others.