I always loved the Needler from the Halo series. It was a really unique design at the time and probably the most fun I've had with any weapon in a first person shooter. Also, the explosions and the ching it does when reloading are just perfect.
Deckard’s gun in Blade Runner was always my favorite. Somewhat uncanny because it was clearly sci-fi, but retained that hard boiled detective aesthetic, like you misremembered a noir shootout.
I have way too little knowledge about the genre in general but there was something oddly satisfying about the Service Weapona.k.a.Director’s Gun from the Federal Bureau od Control..
But I am guessing the part of using it as a game mechanic makes a big difference, there were plenty cool looking things in movies or series — but this one just jumped first to my mind.
The Service Weapon was awesome. It's got an intense sort of gravity around it. Hell, the first interaction with it is fighting a battle of wills in order to not shoot yourself in the head with it. The gun itself doesn't look all that impressive but I do think it's neat enough, and if you look at it from the perspective of the Service Weapon being a character in the story of Control, it's really, really cool.
6 different guns in a such compact form factor for a price of not dying while being chosen to actually use it, with a tiny little perk on the side of automagically becoming the Director of the Bureau with the side hustle of talking with Paranatural Entities/The Board — how’s that too chonky?
The ZF-1. [activates a ZF-1 and holds it] It's light; handle's adjustable for easy carrying; good for righties and lefties; breaks down into four parts; undetectable by X-ray; ideal for quick discreet interventions. A word on firepower. Titanium recharger; 3000-round clip with bursts of 3 to 300. With the replay button, another Zorg invention, it's even easier. [lights reveal a mannequin in police gear] One shot... [shoots mannequin]...and replay sends every following shot to the same location. [turns around, shooting in the direction of the Mangalores; bullets curve their trajectory and hit the mannequin instead] And to finish the job, all the Zorg oldies-but-goldies. [fires every weapon at the mannequin as he mentions them] Rocket launcher... arrow launcher, with exploding or poisonous gas heads, very practical... our famous net launcher... the always-efficient flamethrower, my favorite... [winks to the Mangalores] and for the grand finale, the all-new 'Ice-cube System'! [fires a cloud of liquid nitrogen which freezes the remains of the mannequin. Mangalores applaud politely by carnage]
I'm rather fond of Murphy's burst-fire pistol and hide-away leg holster in Robocop. If we are talking the coolest gun, it's got to be the Zorg ZF-1 from the Fifth Element. https://grabcad.com/library/zorg-zf-1-with-shutters-1
I want to toss the Type-2 phaser from Star Trek (circa 24th century) as my personal favorite. It has this design which reads as a tool more than a weapon, which I love.
I prefer the retro aesthetics of the TOS Type 1, especially for the integrated Type 1, but regardless, it's an excellent choice for the reason you state: it's a very versatile tool!
I love the concept of the Type-1, and it would definitely be my favorite pick of the phasers based on function. But for how it looks, I like how the TNG Type-2 kinda blended the TOS Type-1 concept as a tool, but sized it up to the TOS Type-2 pistol in size. Best of both worlds. Still feels like a tool, but more power drill, less garage door opener or handgun.
I love Daniel Jackson but Michael Shanks is such a d-bag in basically every interview (and there are some very questionable "behind the scenes" stories about him...). In that clip he somehow manages to be the most obnoxious Comic Book Guy fan ever.. while being on the stage.
The 1-2-3 is REAL stupid, no arguments there. Well, specifically, the "3 shots disintegrates" is. The 1-2 is not. Killing someone with a "less than lethal" weapon is just reality. And you can potentially get some real awesome moments when Teal'c or Ronon show how much of a beast they are by tanking multiple zat shots before succumbing.
But also... the 3 is incredibly useful from a narrative perspective and is the same reason that Starfleet uses phasers. Having one prop that can fulfill multiple roles and act as a "get out of plot hole free" card (as mentioned with hiding the bodies) is incredibly useful narratively.
All that said: I do love that the Tau'ri were very clearly about "more dakka". Insert meme about Starfleet being afraid to intervene with other cultures and Stargate wanting to get their Nic Cage on.
I guarantee you've never heard of it because it only appears in a series of novels by Steve Perry, the Matador books.
The gag is, it glues to the back of your hand. The barrel runs along your index finger, and you fire it by pointing your finger and touching the barrel tip with your fingernail.
It fires microdarts which can have a variety of effects, the #1 use being a drug called "Spasm" which makes every muscle in the body contract involuntarily, leaving the victim tied in a knot for 6 months.
The original trilogy of books:
The Man Who Never Missed
Matadora
The Machiavelli Interface
The IMFDB entries for older shooters really show how many misstakes they made, look up Fallout 3, Fallout New Vegas, Half Life, Half Life Opposing Force, Battlefield 1942 and Battlefield Vietnam for some good articles
From a novel so you don’t get to actually see it, but the clockwork diamond pistol from Chasm City always caught my imagination. Mostly transparent and needs to be key-wound.
I'll take the boring route. I respect the gun design of the N7 weapons. They look like futuristic versions of our current weapons but the paint design is on point.
I was an eldar player back when I played WH40k, but the tau railguns are such a great bit of visual design. Perhaps amplified by how terrifying they are to be on the receiving end of.
Destiny has so many amazingly designed weapons. Thorn, Malfeasance, Winterbite, Touch of Malice, all the Ikelos weapons, Conditional Finally, Deathbringer, Eyes of Tomorrow, Gjallarhorn... Weapon artists at Bungie are on another level.
The original gangster will always be the Khvostov 7G-0X and 7G-02; it combines the looks of the modular designs of Eugene Stoner's Armalite platform as well as incorporate the classic beauty of Mikhail Kalashnikov's AK platform both into one sci-fi gun to shoot magic infused bullets.
The Tex Mechanica guns are my favorite. Especially Cayde’s revolver, Ace of Spades. The clockwork sounds and the holster and ready animations where you twirl it… very satisfying.
Two of my favorites are from books and don't have pictures: the nanotech weapon given to grunts in "Old Man's War" and the Soft Weapon from Niven's short story titled, appropriately enough, "The Soft Weapon". There was an animated Star Trek episode based on The Soft Weapon, but I can't remember what I looked like, I just remember the producers weren't brave enough to animate an alien with two heads and three legs.
Other than those, I really liked the silly guns in Ratchet and Clank, epecially the Vacuum Cannon.
The zero G room gun from enders game looks pretty sick. I wasn't that much of a fan of the movie compared to the books but the gun design was pretty good. Also does star lords gun from marvel count? That's a pretty sick one too.