There's a Harris County Deputy who still carries a Colt Python and there are still officers on the Houston Police Department who still tote wheelguns.
Out of all the revolvers I have ever owned, I have had exactly one break a part and it was on a brand-new Colt Python. Parts can break on revolvers. Parts can break on autoloaders, as well. You can accidentally drop the magazine out of many popular automatics; I never heard of anyone accidentally swinging a revolver cylinder in a firefight.
It's comforting to know you're carrying a box of ammo on your duty belt; you can carry about 30 rounds for a revolver with six in the gun, two speed loaders on your belt and a couple more in a pocket. I've know more than a few guys who were pretty darn quick on the reloads. Besides, the OP is talking about an eight-shot revolver - that's M1911 territory and I haven't heard anyone on this forum say that was an inadequate firearm.
There were some pretty famous lawmen who went through some pretty serious firefights with a revolver and not only lived to tell the tale, but took the bad guys either into custody or into the morgue. You may have heard of these gentlemen: Col. Charles Askins and Bill Jordan.
The most natural-pointing firearms I have ever used were revolvers: the Colt Python and the Smith & Wesson MODEL 10 with the four-inch barrel and a Tyler T-grip.
There are advantages and disadvantages to whatever choice you make in a duty weapon. I personally would hate to be required to carry a Glock: Holy Grail or not, Gaston's guns just don't do it for me.