The first, often seen in fighting games, concerns the best characters getting hated not out of a hatedom but for being overused and/or downright difficult to defeat due to their high power, gameplay-wise; understandably, those two points get on a lot of people's nerves and tend to be favored by other people. Characters who are Difficult, but Awesome tend to avoid this fate because they are hard to play well, but disproportionately powerful examples can still earn this status. A typical Tier Induced Scrappy is a high tier character with next to no learning curve, though high learning curve characters who are unreasonably difficult to beat when played by a master (especially if they also happen to be extremely frustrating to play against and/or boring to watch) can and will earn this status. Stone Wall and Gradual Grinder characters are the most common candidates for this trope (especially heavy zoners), though touch-of-death rushdown characters (particularly ones with good approach options) also tend to earn the playerbase's hatred. Characters with massive weaknesses who are strong in spite of those weaknesses are also common targets just based off of principle; people hate Fake Balance, and these characters are often powerful when they shouldn't be. See also Too Qualified to Apply.
The other, more common to RPGs, is a character who is widely hated because they just suck in gameplay terms. They might be the nicest person in the world, but if they're The Load in combat or gameplay, their fate is decided. A Low Tier Induced Scrappy has no Magikarp Power; they're bad from the start and there just doesn't seem to be any point in training them when there are other, more rewarding characters on hand.
The final and rarest breed is a character who has been in both positions at least once; this tends to happen to characters with movesets that are very sensitive to metagame shifts (which can and often will make previously useless characters into rising stars), and characters with awkward or outdated movesets also tend to fall victim to this due to the difficulty of balancing them without giving them buffs that leave them obnoxiously overtuned rather than genuinely good or nerfs that make their whole kit fall apart. Gimmick characters tend to fall victim to this due to the inherent difficulty of balancing a character around one very specific gameplay element, and when they are powerful, they are often frustrating to deal with and/or overtuned to make up for their often glaring weaknesses.
As the page quote proves, it is worth remembering that a Metagame is an evolving and changing thing, especially within competitive gaming. Characters initially seen as weak or useless may prove to be more useful than initially thought, and characters initally seen as a Game-Breaker may eventually go down on the tier list as ways to counter them are discovered. As such, take examples listed here with a grain of salt, especially if it's regarding a newer game.
Games with their own pages:
- Dota 2
- Dragon Ball Z: Dokkan Battle
- Fire Emblem Heroes
- Hearthstone: Heroes of Warcraft
- Heroes of the Storm
- League of Legends
- Street Fighter V
- Super Smash Bros.
- Team Fortress 2
- World of Warships