I enjoy when the villain also has a compelling worldview even if it's messed up. Take the Joker who compares himself to all the evils of the society he lives in and begs the question "Am I really that much worse?" He's the embodiment of what happens when someone gets pushed too far and finally snaps.