Its not the pain that makes me shy away from some guns for concealed carry so much as the effect of too much recoil on accuracy... If I'm already under stress I don't need too much recoil. Too much recoil almost always results in flinching..
One of the reasons I like my little Sig P290 is it has a little more weight, not that 9mms a problem but the little extra weight makes it a steadier platform for me.
44 Magnum power is plenty in a pistol (for me).