yes there are always those that will make modifications to their guns to run the highest and fastest rate of fire (or find a gun that shoots fast and hard) possible but at the same time there's always somebody that will use a pump action shotgun.
my point is, it ultimately depends on your own play style and yes even skill.
there is no "right" or "wrong" sidearm, there is only what you make of it.
quite frankly, it doesn't matter if you give a 6 shot revolver or a 20 shot glock to an experienced player...either way, he'll kill you.
"The Colt Single Action Army, the greatest hand gun ever made. Six shots. More than enough to kill anything that moves"!
-Revolver Ocelot, Metal Gear Solid