The shink ray from Duke Nukem 3D was a delight to use in deathmatches. Shrink your opponent and squish 'em!
This bad boy from Dark Forces:
Concussion Rifle. Sounded like a banshee’s scream when fired. Too bad it got neutered in the sequel though.
Remote mines from Goldeneye for N64. Never felt more like a spy than when you bait someone into charging at you spraying bullets and you just press a button on your watch
The remote charge from Red Faction, cant remember the exact name but it was great for embracing my want to dig around and cause chaos.
The cerebral bore from turok 2.
Gravity Gun.
Hypnosis from Withfire. Very satisfying sound with a beautiful reward of extreme damage
Torn between the classic Doom super shotgun and Marathon dual shotguns.
The Sigil of the One God from Strife. Like, the fully completed gun.
And also the Nuke from Shadow Warrior.
Mechanically, I love the uh… The rifle from UT that had the orb for the alt fire you could shoot with the primary fire for an explosion (I forgot the name). I liked it for rewarding the combo play; even now you don’t see many guns like this.
ASMD!
Voodoo Doll from the game Blood.
Just look, and poke!
Does whatever the hell I can manage to scrounge on Mothergunship counts?
Hellstaff from Heretic, both with and without a Tome of Power
Original Unreal Tournament shock rifle. Nothing has ever been quite as satisfying as nailing a perfect shock combo.
But close second is the Tribes mortar. Tribes 2 especially. The teamplay potential with the laser designator was an incredible bit of design.
The cheat weapons from mercenaries. The portable air strike was a great way to kill an entire screen and yourself if you weren’t careful. The street sweeper was aptly named.
Halo 2 BR. Sooo many kills, headshots, and memories with that thing.
I always liked double pistols in Serious Sam. They had infinite ammo and felt pretty good to shoot.