There's no 'ideal' weapon. It's a fantasy. They've all got plusses and minuses.
In some cases the ideal weapon for the job is going to be a Barret M82, in others, a 1911 or a Hi-Power. For 'housecleaning' duties the MP-5 is just about perfect, but you've got to get to the house that needs cleaning first. Under fire from hidden assailants firing AK's, the MP-5 is just about useless.
They're all some sort of compromise.
Perhaps what is best is to decide on a small 'suite' of weapons and then make sure our front line guys are expert in ALL of them.
But that means more training and more ammo stocks which means more money and a bigger logistical trail which means.....
Well you get it.
Just my two cents.
Yep time too get smart .......have options for each scenario !