Pistols are alternately great and awful in Call of Duty games. I don't recall how they were in Modern Warfare or World at War, but they were super solid in Modern Warfare 2, then they sucked in Black Ops. I didn't play MW3 extensively, but they were great again in Black Ops 2, then they sucked in both Ghosts and Advanced Warfare (sans the M1 Irons, but that's a primary). Then they were good again in Black Ops 3 (although the machine pistol got unfairly nerfed). Hopefully they're good in Infinite Warfare. I'm a handgun man.
Also, in Max Payne 3 multiplayer
The starter pistol, the PT92, is the best weapon in the game. Each carries a smooth 25 bullets per clip, they have a solid fire-rate, a reliable 2 to 3 shot kill at close range, pretty much no recoil, they're pinpoint accurate, retain effectiveness at a pretty decent range, and are super lightweight.
Fitting that the pistols are the best in a Max Payne multiplayer though.