Same here. I have had a knife pulled on me in a dark stairwell, have had several dangerous situations and at no point did I wish for a gun, it would have escalated those situations and made them worse. I have been able to deescalate, shock guys into being nice way more often than I would ever have imagined possible.
I'm not saying NO situation is better with a gun but not nearly as many as you think. Hopefully most people with guns never need to use them. People who sell guns sell fear, it's becomes the "if all you have is a hammer, everything looks like a nail" problem.
Figure if I have made it half a century without needing one, it isn't likely I will need one now.