At close range, a .22 would do the job. The .40 S&W is a cut down version of the 10MM. Severely underpowered, not much better than a .38. The cops like it as it is a "big" round and yet easy to shoot.
I don't particularly like the round, hence the disparaging remark.