Overture revolver with a suppressor and reflex boost is pretty good for stealth ops and taking down multiple enemies at the start of a fight. Seen it do over 20,000 damage crit headshots...
After I'm in the thick of it, surprisingly I've found Lizzie's Pistol (tech) to be a blast. Rapid single shot, charged, or five round burst fire. Give it a recoil remover and a bunch of stacking perks from handguns and engineering and it cuts through enemies like butter. I'm clearing rooms full of perps like Dredd without breaking a sweat.
Fact it's pink means it won't go well with a lot of aesthetic sensibilities, however.