Thrawn is one of the few fiction villains who is also written as an effective leader. It makes him scarier.
And his ending is perfect.Even though most of his troops are very loyal, his downfall comes from one of the many people he abused during his rise to power.