Honestly, after spending countless hours reading every ballistics test I could find, including tests from the FBI and other reputable sources, I've come to the conclusion that the ballistics of pretty much any "regular" pistol cartridge are anemic at best. They can work just fine in some cases but, I think they are anemic from the point of view that the percentage difference in ballistic capability between various pistol calibers with modern self defense ammo is a relatively small percentage difference when compared to even a lower end rifle cartridge.
This is often overlooked in the great caliber debate.
People have been shot full of hot .40 S&W rounds in the vitals and survived while others have taken a single .25ACP round to a not-so-vital spot and died in relatively short order.
At the end of the day, ordinary pistol rounds posses marginal kinetic energy for wounding, nevermind the mythical "one shot stop" that some would have you think that their favorite round does 110% of the time.
More kinetic energy roughly correlates to more wounding potential, but the trick is for all that energy to translate into effective tissue damage rather than a clean cylindrical hole (or a miss because extra-hot 10mm turned out to be uncontrollable in a stress situation).
Pick a cartridge you like, that you can afford to shoot regularly, that is still controllable offhand/weak hand, and that works for you.