Recoil for me with a P226 357 was very similar to a P220 in 45, ie noticable, but not punishing at all. I fine the houge finger grove grips to be too fat on Sigs for my tastes. I've shot the following models: P226 357, P239 357, P220 45, P239 9, P225 9, P228 9, and SP2022 40. To me, the 9's have very little recoil at all, and the rest all feel pretty much the same.
I'd get a CPO P226 from Teknic on this board with both 40 and 357 barrels for $550 if I were in your shoes. Look in the equipment exchange for some of his ads. The P229 is also an awesome piece, but more designed for concealed carry, which doesn't seem to be as much an issue for you. Also, as mentioned above, Ordnance Outsellers is a good place for new or CPO Sigs. CPO's are a great value, many people can't tell them from new, and they cost a couple hundred less.
www.cdnninvestments.com or www.copesdist.com or www.topgunsupply.com for mags.
And finally, the new SP2022 SigPro is a fantastic weapon, and can be had from Ordnance Outsellers for $499 NIB. Its one to consider for sure.