Does it really mean much? The ones that can get what they want get a lot of special purpose weapons for use in specific situations.
Which really just shows no one gun is good for everything.
What is standard issue for such individuals means very little as it may not be what they usualy use.
The rest deal with what they are issued, which can be dictated as much by politics or cost as what is most desired at the time by those in the field.
For such people a pistol is often one of the least important pieces of gear. Proficiency is very important if it is needed especialy in very tight spaces, but it is rarely a primary weapon. That means the selection process for a pistol is not of the highest priority.
Many are less likely to use thier leverage to get a pistol than to get a better primary tool for an objective.
Basing what is an ideal weapon on what a government agency uses is silly at best.
Instead do what those who have the freedom to pick and choose thier gear for each mission do. Pick something that is best suited to your own unique "mission" (whatever that might be), which has its own unique parameters, and therefore its own unique ideal weapon platform.