I can't even believe this is still a discussion. To me it is silly to have to choose.
Packing both has never been a detriment, and in many cases saved lives.
If spray works great, if it does not, I want a backup, or 12 of them.
For every spray deterrent, there have been as many heavy caliber pistol deterrents.