I keep hearing the trend in LE is going to the 9mm. I haven't seen that at all in my neck of the woods. Almost everyone is carrying a .40, and the ones who aren't are carrying a .45. The Gen 2s lasted long enough that the night sights were about dead before we went to 3s to get the rail since weapon lights was the hot new thing. 9mm may last longer, but honestly how many are wearing out the .40 for that to matter?
I'm not smart enough in the realm of ballistics to say what's the best and what's not, but I figure each has an advantage and a disadvantage in any given situation. All I can say is our guys test stuff all the time, and the 165 gr HST .40 has been what we've stuck with for many years now. It's performed very well in police action shootings, has penetrated car doors and glass effectively, and we've had no complaints with it. There is zero push to go to 9mm on my department.