Yes, while still not perfect, a .45 ACP, .40 S&W or even 9 mm handgun is much better for defending oneself. A guy high on drugs will just shrug off the pepper spray. It'll only make him madder.
OTOH, some of the thugs from Mexico and other central American countries, and also Cajun Crooks, might be distracted when they look for their chips in order to take advantage of the free condiment.
So, it's been about ten years. Hey rudy, has your predictions come true?