The appeal of video games can often be linked to dawning a new persona and doing incredible things. It's a way for the player to the feel the gratification of being a hero. We want to be in a world full of extraordinary characters who take on other extraordinary characters in an epic conflict.
Some games though, either deliberately or inadvertently throw in characters who pale in comparison, looking as pathetic as an ant next to a giant. Whether they're in your control, trying to stop the hero or providing weak forms of assistance, none of these characters can ever amount to much in the eyes of the audience.
Some characters on this list may endear themselves to fanbases ironically; a sarcastic type of love. Others though, have irritated fans so much that they spend their days complaining about them on online forums, or even publicly disowning them from the very franchises they were written for.
One way or another though, none of these characters will be earning the admiration of fans or players any time soon. People may like them or hate them, but beyond anything else, they're still pathetic.