I do think there's a very specific age range where cold spray "works", but you're right, it's usually more of a placebo effect more than anything, in the same way that putting a bandaid on an "ouchie" can make everything better, even a fever haha. I'm definitely more in the "hold the limb down with the strength of Zeus and four other nurses to just get it over with" camp myself.