The Gravity Gun from Half-Life 2. IIRC you could pick up objects and hurl them at enemies.

The double-barrelled shotgun from Doom II. The power, spread, and generally plentiful ammo allows you to say "fuck you" in a loud, brash way every time the trigger is pulled.

Controversial opinion, the Doom 64 sound is far meatier.

The Groovitron from Ratchet and Clank. It interacts with every enemy and boss, is pretty powerful under the right conditions, and is the right kind of silly.

Obviously the gravity gun, a more obscure one was the Cerebral bore from Turok 2

OG pistol from Halo CE.

Never has there been anything close since.

The polymorph wand from Realmz.

You could polymorph just about anyone or anything. I polymorphed one of my party members into a red dragon with a misclick and the dragon proceeded to kill the entire party.

Gravity gun at Half Life 2. Flack cannon at Unreal Tournament. Ripper on Duke Nukem 3D. There's plenty to choose from, but they're often only favourites on the type of game they're in (or spesifically for that game).

The medic's crossbow from Team Fortress 2. Also the super-nailgun from Quake.

I don't know if I'd call it my favorite out of any game, but I was always kind of partial to the Dubstep Gun from Saints Row 3/4. Something about it just hits right for me.

That "something" might be everyone in draw distance who you aren't firing the gun at suddenly dropping everything they're doing to hit a dance in the middle of the street.

The rope grappling hook weapon from Just Cause 2. You can move with it. You can attach things to enemies with it. Just play the game if you haven't - so good!

Later games made you able to make more connections etc so you could haul bigger stuff. So it got even better in a way. But JC2 was the best game of them

M-920 Cain Mass Effect. also the black widow sniper rifle.

I'll pick one not listed yet, I think all of Quake's weapons rank pretty high for me, but the Quad Nailgun had this satisfying punchy sound that was always fun.

The Companion, legendary Jakobs pistol from Borderlands 3.

The Wabbajack from Oblivion.

There is always this shitty "attack +1" knife you start out with in an RPG. It's kind of symbolic, I like it, it's like the door to all other weapons and stories and quests and so on.

The [Legendary Guitar Grecotch] from Deadly Premonition. Infinite endurance, infinite smash.

My opinion is kind of invalid, since this is pretty much the only game I play that has items, but well, the Dungeon Crawl Stone Soup devs decided to add guns, uh sorry, hand cannons to the game, a few versions ago.

It's a game with swords and magic, and they did make the guns rare to find, but when you do find one, it's always a blast (pun intended).

The guns are really powerful, but also noisy which means they attract enemies. And they spit out clouds of smoke, which can obstruct your vision when you shoot too much, allowing enemies to draw close. So, it's just a really fun risk-reward loop.

The maul in Silent Hill 3.

Gravity Gun

The Redeemer from Unreal Tournament