I carried the older W-W 147gr OSM 147gr loads when first required to carry a 9mm duty weapon. As I recall, they didn't ask for my opinion.
Later we were given 147gr Hydra-Shock because of some informal testing done by a couple of folks within our agency. Again, I wasn't asked.
As time passed we issued the 127gr +P+ RASXTP and then the RA9TP loads. I had some input onto that decision, but it was only based on some anecdotal info received from a feed agency who used it when they qualified at our range, and some early things being reported by some LE agencies who were using it. The Winchester rep was selling a LOT of it, too.
Later on we switched to the Rem 124gr GS +P (non-bonded) because it was on the state contract. The latest state contract has the Win RA9124TP T-series 124gr +P load on it, so I imagine I'll eventually start seeing that in the inventory at my former agency when I show up at the range.
I've also used some other various loads from the major manufacturers over the years, when duty loads were a mandatory issue thing or when ammo for off-duty weapons had a looser requirement. This included Speer 124gr +P & 147gr GD, Rem 147gr GS and even some Rem 115gr +P+ (although I mostly shot that up for training). I've even got some 147gr RA9T sitting around somewhere in my ammo supply.
The long and short of it is that there's a lot of good quality 9mm defensive ammo being produced which use some newer designed hollowpoint bullets that have been refined to offer better performance, and often do so within a wider velocity window (since the ammo companies realize that cops are going to be using shorter barreled guns for plainclothes, secondary/backup & off-duty roles).
There's still some of the older style traditional JHP's being produced, especially in the low-cost, bargain product lines, too. The stuff which didn't offer robust expansion when fired through many of the more difficult ballistics testing scenarios.
When it's all said and done, though, it really comes down to how well any given load feeds, fires & functions in any particular pistol, in the hands of any particular shooter. Lots of statistics still indicate the potential for an unfortunate number of misses among the wide spectrum of LE agencies. Misses with great bullets aren't any more effective than misses with older style hollowpoint bullets (or FMJ, for that mater).
Once I reached the point where I was much more concerned about my consistent training, practice and skillsets, regardless of what ammo I was issued (without choice), or authorized to use. I realized I could really stack the odds more in my favor if I was a better all around shooter and really focused on my training & practice.
Then there's that whole issue of understanding and trying to train to anticipate and mitigate the adverse effects of hormonally induced physiological problems caused by the fear response.
You have to hit the intended target, regardless of whatever round you're using, after all.
I still like to have one of the better designed & performing modern defensive loads, given my druthers. Right now that seems to mean the RA9TA 127gr +P+ and the Rem 124gr +P GS. I've got one or the other of those in my different 9mm's, depending on what's at hand when I'm loading mags.
That doesn't mean that's what I'll be using in another year or two, though.