Note, if you will, that when cops have the chance to choose and are not hamstrung by PC minded town councils, they prefer John Browning's best. Even the fibbies have gone back to the .45 as a carry piece.
I can personally attest that I watched a Spook, (the Agency kind) put a 30-some round magazine from a 9mm Swedish K into a goober, and wound up caving the guy's head in with the pistol grip and a ballbat swing.
The "spray and pray" method is only good in Hollyweird. Remember, they also invented the sideways 'gansta' hold, which is the best way to tell who is going to win a gunfight.