He is ultimately defeated not by Luke Skywalker, but by his own subordinate, Darth Vader. He did not foresee Vader/Anakin wising up and casting him into a reactor shaft, hinting at an egotistical nature that does not see what he feels he controls utterly as anything but tools.
Later in the Expanded Universe, there are debacles with clones of his. The man even had contingency plans for death, it seems.
Palpatine in FanficEdit
Most Star Wars fanfiction barely mentions him, except in passing or in his original role. He is not a common (or even vaguely present) Lust Object, and his evil nature is completely beyond redemption. Sometimes goodfic will include him to a degree, but most mediocre fic doesn't concern him or doesn't even bring him into the conflict.
Palpatine in BadficEdit
Palpatine is mostly seen as a 'dirty old man' because of his ugly appearance, and as an obstacle to Sues going after either Darth Maul or Anakin Skywalker. He is sometimes bashed by badficcers, making him far too easy to defeat or causing him to be much more stupid than he really is. In reality, he is an insanely powerful Sith Lord and was capable of defeating Yoda in single combat. He was able to manipulate the Republic into becoming an Empire. Portraying him as a minor threat or making him stupid are probable charges.