The appeal is because they have been idealized, they were nothing but ignorant humans, not supermen in any way, and because people long for power.