hmm...
Fallout 3's BB-gun - like, what?!
Mario Kart's (single) bananas - unless you drop it right in front of someone's nose, no-one ever will ever drive over it ever
Counter Strike's Dual Elites/Berettas - no damage, no accuracy, no use
Vampire Bloodlines - the little revolver-thingy - lolw00t?? (real vampires fight melee only, anyway

screw them pea-shooters!)
Doom 3's assault-rifle/machine-gun thingy - derp.
aaand Max Payne's Ingram - spray 'n pray, but keep in mind: there is no god that could answer your prayers xD
i also completely agree on ME 1's sniper rifles (the strong ones generated too much heat - give me a decent AR any time; also, sniper rifles are for range - there was no range in ME. ever. (ok, except maybe at the end, when Sovereign was at the Citadel, but then you should have ARs so good that you can "snipe" with them)), and Goldeneye's (gosh, how can one make a game SO awesome??) Klobb. which hit nothing. and if they did they dealt no damage.