Personally, I think the best kind of a villain is one who is being bad to actually support the greater good. So, in a way, they become the 'monster' to slay the real threat. Take Handsome Jack from Borderlands for example, he became the 'bad guy' to try to save the world. It only appears that he is evil (But, he is mental though) to the players at first. That is what I believe.