Gonna try to make a list actually, from the best to the slightly less best:
1: Double barrel shotgun in Doom 2, for that ridiculously deep KABLAM!!! Hell, even the reloading sound is cool. 10 years later, there’s been a lot meaner weapons, but this weapon still defines what ass-kicking sounds like. Also fun to use, requiring you to pretty much touch the enemy with the tip of the shotgun before pulling the trigger. Killing just about anyone in one shot up close, you could blow an enemy to kingdom come, step right through the mincemeat that used to be a space marine and be around the corner before the bloody chunks even hit the floor. Good times, good times.
2: The modified MP5 from Half-Life, for letting me fill an entire room of enemies with bullets and then blow them away with a barrage of grenades without skipping a single beat. I pretty much used that weapon all through the campaign, untill I ran out of ammo. So I didn’t get to use it much. My definite weapon of choice if I was ever lucky enough to stand between earth and hordes of aliens bent on destruction.
3: Shrink Ray from Duke Nukem 3D. You know why.
4: Light sabers from Jedi Knight 2. Perhaps more so the dual sabers in Academy. Ludicrously unfun to play with, rendering you so powerful the game wasn’t even remotely challenging anymore. You could leave the game in an area chock full of enemies, go eat dinner and return not having taken a single point of damage. Killed everything faster and easier than any other weapon in the game. Light saber duels had no debth, no finesse, just random clicking and running.
But my GOD were they cool. Anything else about them just becomes a non-issue, those things ROCKED!
5: And then we have the otherwise fairly unremarkable game, Shadow Warrior. The nuke. A blast so gigantic that the hardest thing about using it was not killing yourself. You had to send it flying and basically go hide behind a wall or inside a building. It killed everything. Complete with giant mushroom cloud filling the skies. I remember nothing about this game except the exact design, complete with details, about the areas where I got to use my nuke. Imprinted on my mind forever. Holy shit.
6: Rocket launcher from Quake. As a weapon it was so overpowered it quickly became pretty dull, but it lands the fourth place because of that beautiful piece of game-design oversight known as rocket jumping. Added a whole new dimension to fps gaming.
7: Counter-strike’s AWM. Just for knowing how unbelievably frustrating it is for an enemy to be killed in one shot by an enemy so far away that he couldn’t even see me. Totally imbalanced, but truckloads of amusement. The whining alone…
8: Pipebombs, also from Duke Nukem 3D; you could drop 50 of them in an area and blow them all up at the same time, preferably right after someone spawns right in the middle. Barrels of fun. You really can’t go wrong with big-ass explosions.
Honorable mention:
Banana peels in NOLF 2. Again, no real explanation needed.