I'm not going to pretend to address an isolated LE shooting incident at which I either wasn't present
and involved, or wasn't afterward directly involved in the investigation, privy to
all the details.
I'll offer some comments and thoughts about firearm "reliability", in general, though.
It's not uncommon among LE firearms instructors and armorers to hear that day in & day out, the single most significant cause of a handgun stoppage, malfunction, etc is ... the shooter. Shooter-induced stoppages and malfunctions are probably the cause of 90-95% of the "problems" encountered and observed.
Ammunition is the next largest probably cause of "problems" followed by the
smallest cause of "problems", percentage-wise, which is an actual gun problem.
Now, these things can be compounded and skewed a bit further by the use of old, worn and damaged springs (especially recoil & mag springs) being involved, or improper maintenance (especially at the user level, and not caught & corrected by an armorer).
Then there's the environmental influences that can occur (sand, grit, water or other liquid contaminants, temperature and humidity problems, etc).
It's the
shooter related things that can occur most often, though, and especially when things start happening fast and getting fuzzy.
Something as simple as unintentionally not letting a SA trigger recovery sufficiently to reset. This can happen more than you might think, and not only in people using TDA guns (Traditional Double Action, but also called DA/SA), but even in DAO/DAO type guns. Shooters get excited and start trying to fire faster than they let the gun recover and be mechanically ready for another shot.
It certainly happens when folks are shooting DA/DAO revolvers.
Or, they "short-stroke" the pump on a pump shotgun (or forget to pump it after the first shot).
Shooter injury? That's a BIG one. If the shooter's hand or arm isn't able to function properly, how can you reasonably expect to operate the gun normally?
Over the more than 20 years I've acted as a firearms instructor, watching both LE and non-LE (albeit mostly LE), I've long since lost any illusions that virtually any handgun (shotgun or rifle) can't be caused to experience some stoppage or other malfunction by something the shooter does, or doesn't do properly.
I've "fixed" far more reported and claimed "gun problems" by "fixing" a shooter.
The next group of problems has involved insufficiently and excessively lubed guns. Both can be a problem at some point.
Semiauto pistols ... of modern design, good quality and modern manufacture ... maintained properly by the shooter/user (and periodically inspected, maintained & supported at the armorer level) ... used with fresh factory ammunition or the proper caliber and good quality ... ought to be as near to totally reliable as someone could reasonably expect. That doesn't mean shooter, ammunition & environmental circumstances & influences can open the door enough for Mr Murphy to slip inside and cause problems, though.
Revolvers? Ditto the modern design, good quality, maintenance, used with good ammo, etc.
The disclaimer here is that they're generally harder for a lot of folks to use. Less ergonomic grip stocks and grip angles, heavy and long DA triggers (which also require full recovery in order to be ready to mechanically fire again), more shooter actions for unloading & loading, and then there's some sharp edges and corners to catch the unwary shooter's thumb ... cylinder latch and the rear of the cylinder ... and you do NOT want to get an errant finger near the barrel/cylinder gap. Hot gasses and occasional bullet/jacket fragments slip out the B/C gap.
As an armorer, I'd much rather detail strip and inspect a number of the pistols for which I've been trained to support than a DA/DAO revolver (I'm also a S&W revolver armorer).
All of that said. I carried a revolver as a young cop, and I'd not be adverse to carrying again if I had to return to uniform duty (but I'd prefer it to be one of the light weight Scandium N-frame .357's that weigh a lot less and hold 8 rounds
).
I often carry a 5-shot snub, but I'm a long time revolver shooter and can still shoot them passably well.
I also carry a number of subcompact, compact & full-size metal & plastic pistols, as well.
I trust ALL of the ones I carry (and support as an armorer) to operate as designed and intended.
FWIW, I've had to repair/correct both some DA revolvers and some plastic pistols lately (and some AR's ... but I can now leave much of that to a couple other armorers, and the shotguns to another armorer).
Things happen.
Someone can risk them happening more often if someone tinkers, modifies or "improves" their handgun, too.
Stoppages and malfunctions can be different things than "failures", but then we would end up getting into some of the reasons LE are taught about clearing stoppages & malfunctions, as well as transitioning to other weapons (secondary, slung rifle or shotgun).
Even so, now that I'm retired I don't have any particular nagging worry about
my properly maintained handguns
and magazines experiencing stoppages or malfunctions. I inspect the good quality factory ammo I use, to the degree possible visibly, and don't lose sleep worrying about the occasional ammo problems I've observed and experienced on the range over the years.
Things can happen. I train for the unexpected, continuing to do so since I'm keeping my hand in things as an instructor & armorer in my retirement ... and hope to never need to do it off the range.
Just some rambling thoughts.