The problem is- we just do not know what would have happened if there had been no gun.
I used my gun (I used to have a CCW) twice- once when walking to the train station in the winter dark in SF, escorting a couple of female coworkers. Two homeless guys lurched out of an ally, saying “Give us some money”, one had a board with a nail thru the end. I simply showed by gun, said something, he dropped his club, and nothing occurred. So- could we have just thrown a couple bucks at them? I dont know. But the women were scared shitless.
Next time was at a 24 hour newstand/bookstore. We heard noise, the clerk grabbed his baseball bat, and I followed. There was a guy pulling a women by her purse into a dark alley. The perp saw us coming, with my gun out, let go of the purse and ran away. Would the clerk with the baseball bat be enuf, or maybe he and I (with no gun out) as a show of force? Sure. Maybe. She was shaken up, the clerk gave her a cup of coffee, she didnt want to wait for the police, but she was effusive in her thanks.
So, you can say in both cases, the gun did nothing. Or you can say in both cases the gun prevented a violent crime. I honestly can’t say either way, except we did feel more secure.
That’s the issue- did the show of firearm force prevent a crime? Or was it unnecessary? My WAG is about half the time, it was unnecessary- except for the feeling of security. But that’s not nothing.
However, in neither case was anyone shot, either. So, maybe not necessary, but no harm was done.
Now, we do have some cases where a good citizen or off duty cop or security definitely prevented a mass shooting, murder, rape etc. Those are, admittedly- rare.