I've actually found the .44 Magnum Revolver to be quite effective, or the HK p390c. If you have sufficiently high SG skill, you can get quite a lot of Instant Kill criticals. They also have a low AP to use them. (4 normally, as low as 2 with the Fast Shot Trait and the Bonus Rate of Fire perk)