If you are an agency who has to arm and train a lot of people, you have different needs and worries than a guy who needs to defend his home. I’ve watched six SEALs show up with more ammo than what an infantry battalion gets allotted in a year, and then burn through it in less than a week.
At that level of shooting, you don’t need the best ever. You need adequate at the best price. Honestly, there are hundreds of decent choices that will throw a 9mm bullet at a target adequately over pistol,differences. People may have individual preferences; but cost of the system is the big factor.
As far as SEAL training, I’ve had lots of fun conversations with SEALs who’ve killed real people in real fights and, from my perspective, didn’t have the slightest idea about why they were given any particular weapon to do it. Even for SEALs, it’s mainly just a tool for a lot of them. It works or it doesn’t or you just learn to put up with the eccentricities because that’s what you’ve got.