Thing about the Army is that they are restricted to the use of ball rounds.
No expansion with ball, so the bigger it starts out, well the bigger it stays, so anything larger than a 9mm will make a bigger hole.
With expanding ammo, it is a different ballgame.
Back in the 80s, before they started designing bullets to meet the FBI requirements resulting from the 1986 Miami shootout, there were some numbers around about the efficiency of different calibers stopping power.
I don't recall the exact numbers, but it is not to critical here.
The .45 ACP came in near 90%...maybe a bit higher or lower...I seem to remember numbers of 87 or 92.
The 38 Special was near 80...I remember 77, but it is somewhere around there.
The 9mm was several points below the 38 Special.
Those were the "common" sd rounds in use and the choice of 45ACP was pretty obvious, to me at least.
Then they started work on bullet design with the 40 S&W and Black Talon being among the first in the early 90s..
This resulted in significant improvements in ALL calibers using these rounds. However, because the room for improvement for the 45ACP was small, it might have gained a % point or two but the 40 S&W and 9mm moved into the upper 80s..near were the 45ACP lives.
Put +Ps and all that in the mix and it's all a new ballgame.
However 3 concepts still prevail.
1. The round must penetrate reliably to be consistently effective. 12 inches in ballistic gelatin is deemed the minimum for reliable stopping power
2. Over penetration is a No-No. For two reasons. A. if the round leaves the target, the target does not receive all the energy dump available for the round, and, more importantly, innocents beyond the target are endangered by the round. 18 inches is deemed the maximum penetration in ballistic gelatin to limit over penetration.
3. Expand as much as possible while staying within parameters 1 and 2 above.
While I know nothing is an absolute predictor of performance, this is at least a relative measuring stick.
Also, I know that the lessened energy dump of an over penetrating round might not be a concern. A .32ACP might penetrate to the required 12 inches and dump all it's energy in the target while a .50BMG will likely go a bit beyond the 18 inches of gelatin but will dump more energy and do more damage than about anything else heading down range.
Next, the effectiveness of high speed in pistol rounds is not an established fact, well at least to some. Some say rifle velocities need to be reached before hydrostatic shock becomes a factor. Others point to the difference in the 38 Special and the .357 Magnum saying the difference in effectiveness is due to hydrostatic shock.
Lastly, the increase noise, muzzle flash and recoil of higher powered pistol loads might cause decreased shooter effectiveness under the stress of a self defense situation, particularly in low light.
So there you have it....
Oh..remember, like Tom B says, the best gun/caliber combo for you is the one you will always be willing to carry.