There's a "short list" of good guns, depending what you want.
Morissey Elan: gets past MAD, very concealable
Yamaha Sakura Fubuki: Light Pistol and can do fully compensated narrow/narrow, no mods needed. If you just care about Stick-and-Shock, best gun.
Ruger Thunderbolt: Heavy Pistol, you have to mod it, but it is the only heavy pistol that can hit 5 recoil compensation (enough for two bursts with no penalty) without the user having inherent RC. Better than the YSF for non-SNS.
Ares Viper Slivergun: narrow niche - if you have inherent recoil compensation (such as from a cyberarm gyromount or very high strength), you can get 5 RC on it. It can only fire slivers, but unlike the other burst-firing pistols, it can fire wide as well as narrow. It's strictly worse than the Ruger in every situation but wanting to do wide bursts.
Ruger Super Warhawk: niche use of destroying vehicles, since it has high base damage and Armor Piercing. You can mod it to have burst-fire, but you need a whole lot of inherent RC to actually use the burst-fire, and it doesn't hold enough ammo for it to be really useful.
There's a few other guns with super-niche uses, like the PSK-3 collapsible pistol, the Lightfire's super-silencer, and tasers (the main reason to use tasers over SnS is that tasers are legal, not restricted).