Favourite examples of a powerful/cool characters who end up being completely pathetic.
There's something interesting about a character whose first impression is that they're imposing and powerful. But then you see them later, and they're just completely pathetic.
Zant from Twilight Princess, I feel is a perfect example of that. He's imposing at first, but the more you see of him, you realize that he's kind of a bumbling idiot with a goofy moveset.