I'd opt of the regular Redhawk, since I shoot one. The Super Redhawk is really a big gun.
Recoil in either the Super or standard Redhawk will be noticable, but not intolerable, with standard magnum pressure loads. Hold it firmly but let it do its thing during recoil. If you aren't tense with it, it will settle back down where it should be for the next shot. Don't lock your arms and all that nonsensical stuff or you'll put it away and never shoot it again.
With a good gun, good grips and good technique, you'll able to shoot 100 rounds of 240 full pressure 44 Magnum loads with no problem. I used to do that couple times a week when I was shooting hunters pistol. My biggest qualm was the cost of the ammo, even at reloading prices! You'll have to work up to it, but using good technique, you won't have any problem. And being a double action revolver, you could learn to shoot it very fast.