3. Lord of the Rings: Having a Super Bad Guy that actually is the Super Bad Guy in the plot is a good thing. He might not even need a huge 'angle' other than "I want to take over the world and enslave everyone." Simple can work really well if it's done right. But Sauron was cool because from the start, you knew he was the Big Evil in the story. There was not some Secret Hidden Final Boss You Didn't Expect.
I would not consider them 'the norm'. We haven't had a playable character die in... what... 16 years?
EDIT: Changed the title, perhaps that's more appropriate.![]()