My EDC is a NAA .22 Magnum mini-revolver, loaded with Speer Gold.Dot short barrel loads. For its intended use, it is enough gun for me. I practice with it A LOT. Average is 2 shots into a grapefruit at 10' in slightly under 2 seconds. I don't see any threat being continued after being shot in the grapefruit a couple of times. If you are willing to put in the time, practice, and cash for ammo, I see no reason it will not work for you. Yes, there are better choices, but if size is a primary concern, as it is in my case, it is significantly better than a sharp stick. It can easily save your life.
Whether the vast number of folks out there agree or not, I know, for a fact, any gun, when needed, is better than no gun.
Use whatever you feel comfortable with. I truly hope you will never need it.