Spray and pray is a bad tactic, but it has nothing to do with the gun, that is simply a function of the shooter.
Volume of fire is a thing, revolver or auto, and since handgun rounds basically suck as man stoppers, it only makes sense and takes no more effort to quickly and accurately fire 2 or 3 rounds as it does 1. And which one do you suppose will give you better odds at stopping things quickly?
As far as the revolver being self contained and the idea the autos are so fragile, that's really not even close. I regularly shoot a good bit of both and overall, the guns Ive had the most trouble with, if and when there was trouble, or require more work on your part, have been the revolvers. And if one is more fragile, and more prone to stoppages that cant be resolved in the moment, its the revolver, hands down.
As far as reloads go, if youre carrying a gun, of any type, you should be carrying a reload, well versed at doing them, and be able to do it without thought. It doesnt matter that in some cases you might not be able to do it, there are reasons why you might need to. And if youre worried that reloading might be necessary due to lack of round count and could be an issue, then youre not carrying the right gun. There are guns that help reduce that worry.
In order to be capable and proficient with whatever it is you choose to carry, you need to be able to work and shoot the gun in a realistic manner and know its MOA to the point of working and shooting it without thought. Carrying it, the draw and presentation, sighted and unsighted shooting, reloading it, dealing with stoppages, knowing how best to use the gun as an impact weapon should you need to, etc, is all part of things here.
Realistically here too, the only way to know what is or isnt relevant, is to be as well versed as possible with as many different things as you can, so you actually have a true idea of what is and isnt, and can make a realistic decision.