I do not care what police agencies may have adopted a specific load, but do care what LE officers have actually used, time after time, in real-world incidents. If there has been a significant history of failures-to-stop, there will tend to be chatter about it.
I work for one of the largest PDs in the USA, and we shoot a number of bad guys. The mandated load for uniformed officers, from 1997 to 2012, was .40 S&W, but it was phased-in, with nobody being required to change duty pistols, as we buy our own duty firearms, and making vereran officers spend money does not go over so well. (In 2012, .45 ACP re-joined the list of approved duty cartridges, and in 2015, 9mm regained its approved status. This year, 9mm became the standard duty cartridge for new-hires, so .40 S&W will gradually fade away, due to attrition.)
Well, the good news about .40 S&W, is that all the decent duty loads seem to work well, if the shooter does his part in placing the rounds well. We have to buy our own duty ammo, within guidelines, and for while, Gold Dot was very popular, due to local availability, and lately, Hornady Critical Duty was been more available, with Gold Dots becoming difficult to find. Winchester Ranger has a local following, too.
I voluntarily transitioned to .40 S&W in 2002. I used 165-grain Golden Saber in my G22 duty pistols, 2002-2004, because it was locally available, in quantity, for a decent price, shot well for me. When I switched to SIG P229 pistols, in 2004, I found that 180-grain Gold Dots shot better to point-of-aim. Both 165-grain and 180-grain Gold Dots seemed popular in my area, among LEOs, and Milwaukee PD officers seemed happy with the street results of their issued 180-grain Gold Dots.
I returned to using 9mm and .45 ACP duty pistols, starting in 2015, because shooting started to hurt, about age fifty. Yes, .45 ACP has more recoil than .40S&W, on paper, but .40 S&W seems to have more Snap & Whip, pun intended. Plus, all-steel, full-sized 1911 pistols have a nicely low bore axis, and pleny of mass to damp the suddenness of the recoil impulse. Yes, I can, indeed, carry a 1911 in my duty holster, in one of the largest cities in the USA. Life is good. (As a matter of practicality, however, a G19 works better, as a duty pistol, while inside our terribly small new patrol vehicles, particularly with a right-hand holster, while in the passenger seat, or a left-hand holster, while in the driver's seat. I wear a size 34 duty belt, so being "big" is not the issue.)
Regarding the poll, I did not "vote," because I do not know what shoots to the all-important point-of-aim in others' pistols, and some of those loads are unfamiliar to me.