Pistol calibers suck. That's reality. A pistol is what you use when you don't expect a problem. If you expect a problem and can't make arrangements to be somewhere else, taking a pistol is not not very smart. You need a rifle.
That said: if you look at real world experiences and testing, put together by people who know what they are doing (like Doc Roberts), there is no measurable difference across large numbers between the various common service calibers (9m, 357Sig, .40, 45ACP). I have a .357Sig (G33) that I bought mostly as an experiment. It is LOUD, expensive, LOUD, and not fun to shoot. From an objective analysis, the G26 was a better choice, especially when one considers the logistical nuisance of maintaining different calibers. I have no use for .40, in no small part due to logistics; if I had to have one, there is no doubt I would go with the Smith M&P. I am selling my Yam 10-8 1911 because I can't justify the tied up capital, but do have another .45 and a revolver being converted by Bowen to replace my stolen 625. I like the round for a lot of reasons. Day in, day out, across large numbers of shootings, a quality 9mm round from the list Gary provides, from a reliable pistol wielded by a person who has made the effort to be skilled and have the right mindset, is a winner.