yeeeeah, definitely not suitable for cops
If you want to argue about police tactics, recruitment, training, or purpose, this isn't the place for it. This is a thread about pistols and trigger pull weights.
As for military duty, that should be a plus for police duty. Military soldiers have to learn about things like "rules of engagement" and had very strict training about that. If they saw combat, then they are also much less likely to lose their demeanor when dealing with a rough situation, because they've already seen much worse. The cops who have all the problems seem to be ones who were never in the military, and probably would have been (or were) rejected if they had applied: basically thugs who want to play soldier and never got the chance. Notice that you never hear about problems with military police (MPs) shooting people unnecessarily, despite the extremely high numbers of non-white people in the military? I think there's a reason for that.
It sounds like the big problem is shitty training for cops.
The problem in NYC has been well-documented by gun experts, it's not the number of people they're trying to shoot. There have been many cases of them shooting at legitimate targets (not black guys running away, not small black children with toys, but real suspects wielding weapons on the street) at hitting bystanders because their shot accuracy is so pathetically bad. A 12-lb trigger pull (specifically designed into Glocks that were never meant to have them, at the insistence of the NYPD because they were used to crappy old revolvers) is a big part of that.
If a cop shoots a suspect on the ground, that's just plain murder, I don't care what their excuse is. Bad trigger discipline should be prosecuted as murder: you never put your finger on the trigger unless you've decided to kill the target.