Sluggy Freelance's Sam, being a vampire, is way stronger and faster that most of the cast, survives a fight with a major demon and is a Jerk with a Heart of Gold. Unfortunately for him, the only thing he cares about is having sex with as many women as possible, which he is awe-inspiringly terrible at, to the point that his normally extremely potent vampire hypnotism is entirely ineffectual. However, this is the result of Flanderization. In his early appearances, he was far more clever and successful with the ladies until he fixated on Zoe, a girl he couldn't get. Continuous failure made him what he is today.
Starslip's Memnon Vanderbeam: He is good at his trained profession (Art expert) - just not as good as he thinks he is. And he thinks that expertise transfers to his current job (Starship captain/cultural ambassador). His arrogance and intellectual snobbery don't help.
Although he's nowhere near as competent a ship's captain or military strategist as his second in command, in a recent war games incident where things unexpectedly went hot, he was shown to be a fairly competent tactician in the heat of battle.
Guilded Age The bard in this series, Payet Best, becomes this after he visits a small town and gets hailed as a hero. Lampshaded with the Achievement Unlock: Become a huge Douche.
Exterminatus Now has this in the form of Rogue, who, being the only member of his four man team who isn't idiotic, ax-crazy, or downright repulsive, tends to act in a "better than you" attitude, despite not being that much better than his compatriots.
He was temporarily replaced with neophyte Wildfire, a young lady from Japan-analogue, which looked like at least one of the guys was trying to get in her pants until she pointed out that she had a couple of plasma swords not dissimilar to the one they became familiar with as Rogue's weapon of choice.
Erfworld has Stanley The Tool, who is convinced that he's destined to collect all of the Arkentools, despite the fact that he's a bungler with no concept of strategic warfare, diplomacy, or logistics.
He did seem like he was going to be brought down a peg when Wanda became attuned and wound up getting more amazing powers than him, but alas, it was not to be!
Eridan Ampora from Homestuck is an arrogant snob who feels entitled to love and reverence, yet most of his peers view him with opinions ranging from pity (platonic, of course) to outright loathing.
Cronus, if anything, is even worse. He's totally convinced that he is a sensitive, artistic soul who is a musical genius and an all-around selflessly nice guy. In reality it's perfectly plain to everyone that the entire thing is just an act to convince people to sleep with him. While Eridan did actually have a good friend in Feferi even after they stopped being moirails, Cronus is disliked by literally every single other character who has ever come across him. Ouch.
