I think I know of the case you mention if it is the gentleman who was injured in the accident. It was a good story and he came back strong and proved his place in the cockpit.

Gaffman. It sounds like your biggest hurdles will be the hurdles the FAA throws your way but it looks like you have that under control at the point. You are likely at an advantage in that you were born the way you are. You have learned to adapt from birth to do anything and like others I have no reason to believe that you couldnt handle a transport category aircraft. I can only speak for the Q400 but it is sensitive in pitch which is no big deal but heavy in roll. If you would have no problem gripping the yoke and handling the heav(ier) forces you should be just fine. On the FO side of the house, everything you need is done with your left hand anyway. I dont recall there being any emergency procedures in the Q400 that require two hands although on the CA side there is only one I can think of which is runaway aileron trim.

Nothing to offer procedurally wise with the FAA and the hoops involved but from what you describe and the things you can do (I dont even rock climb) there would be no problems with the airplane.