If you are intent on something and very enraged, a spray will not stop your advance at close distance. Lead, on the other hand, is very effective at close distance when launched at a fast velocity, in thwarting an advancing predator. Both the animal kind and the human kind.
I would use my 460 S&W or 500 S&W revolvers with hard cast bullets.