Laconic / Memetic Loser

A normally competent character's weaknesses are exaggerated in fanon, to the point where they become a walking punchline.

http://tvtropes.org/pmwiki/pmwiki.php/Laconic/MemeticLoser