I freely admit I'm not a fan of recoil. I can shoot a limited amount of +P through my 642 without too much difficulty. Too much, and I'm icing my hand for a couple of days.
I once fired 5 rounds of Buffalo Bore's +P FBI load, which is like .38 Special +P+ or even low-end .357 Magnum power levels, through my 642. My first thought after was, "Well, I'm never doing THAT again!"
To me, increased blast, flash, and recoil outweigh any advantage the increase in power to full-strength .357 Magnum may have, especially in a lightweight snub.
There are light and mid-range loads available. I've used the Gold Dot SB-GDHP in .357 Magnum in a 3" 65. I might consider trying that in a steel J-frame. I was also fond of Winchester's 110gr SJHP, which was ballistically similar to 9mm 115gr +P, IIRC. That might be worth trying, though I know in some of the scandium snubs there are bullet weight restrictions. Should be fine in a steel J-frame.
Back when I used to read gun magazines, I remember one article by John Taffin. He's known for shooting lots of heavy-hitting, hard-recoiling guns. In this article, IIRC, he said he had started experiencing nerve issues in his hands from all the magnum shooting he'd done. Something to think about.
And, finally, some words of wisdom...