I know what you're saying, and I know it's the reason there are so many snubbies without spurs, but I can imagine a number of situations where I might use my snubby SA.
And like has been said ... they're surprisingly accurate.
On television they use cocking the gun as a cool effect to show the BG you have at gunpoint that you're serious ... but I don't know if that would work for real world SD. If you're brandishing in the real world, the bad guy is either becoming real compliant real fast or you're shooting at them -- not debating with them. The secondary threat level, beyond holding a lethal firearm, doesn't really matter.
In my case I carry my snubby loaded with .357 when I'm hiking or in the woods. I know I lose a lot of the .357 power with the 2" barrel, but it's considerably lighter than my 4" and I think it's still going to hit a bear harder than a .38 +P (not that I've ever been confronted by an aggressive bear in several decades of camping and hiking, but who knows when it could happen?).
And in the woods I can imagine needing to make an aimed shot SA, including at a 2 legged predator (the only ones I really feel a need to carry against, anyway).