Yeah, you heard me, overrated weapons/characters/specials in gameplay terms: Basically name all the crappy, useless things in video games that everyone seems to love for some unknown reason.
Freezethrower - Weapon in Duke Nukem 3D (Various)
This weapon sucks. If you miss, the shots bounce around and hurt you and if you're fighting more than one enemy at a time it's pretty much worthless as you have to run around trying to get Duke to automatically kick them. It's a nice novelty for taking out a single enemy standing in front of you when you have a clear shot, and it also serves as a decent enough rapid fire weapon for use on bosses when your other decent guns run out (I killed The Queen with it), but other than that I just don't bother.
D5K Deutsche - Weapon in GoldenEye 007 (N64)
A subpar machine gun that makes too much noise, does the same damage as all the other normal assault rifles (in other words, not the P90 or the AR33) and doesn't even have a zoom function. At least the ZMG has a faster firing rate. Skip this piece of crap. (The Klobb is obviously worse, but everyone knows that thing fires drawing pins so it's irrelevant to the topic)
Black Mage - Class in FF games in general
Yeah, you knew this was coming. They were good in FFT (maybe FFTA too but I don't play it) but that's it. Moving swiftly along...
Yang - Character in Final Fantasy IV - FFII on the SN- wait, bugger it. If you're still not using the Japanese numbers, which have been in official use in the US for the last eight years then you shouldn't be breathing... in Europe they've never NOT been the Japanese numbers, how about that?)
He takes hits like a schoolgirl, takes forever to act when you give him a command (a character issued with a command after he is will often go first) and doesn't really seem to do exceptional damage at all.
Chaingun - Weapon in DOOM and DOOM II
Inaccurate, doesn't do much damage, the only saving grace is that it's a bullet weapon so it won't be dodged like the Plasma Rifle. DOOM3 seemed to upgrade it, but now it just runs out of ammo fast and needs constant reloading.
Dias Flac - Character in Star Ocean 2
Is it just me or does his basic physical attack miss all the time? At least his Air Slash is faster than Claude's, but Claude has Dragon Howl and Mirror Slice later on, plus he's meant to be a melee character.
Mario - Character in Super Mario Bros 2 (Super Mario USA in Japan)
He's a bit slower than Toad, doesn't jump as high as Luigi, and can't float like the Princess.
Luigi - Character in Super Mario Bros Lost Levels (SMB2 in Japan)
He jumps higher but when he lands he'll just slide off the platform. Even though he seems like the obvious choice, the game's easier with Mario.
I'll post some more as I think of them, but for now does anyone have any to share?