Hijinx,
I am Mr. Tear into Anything at least once. Gear boxes have scared me for ages since I have personally had the unfortunate experience of having them rebuilt by professionals and still fail not long after the rebuild. The part about the auto that gripes me is for the most part you don't know if it will work until it goes back in the car. Or shall I say it is hard to test what you have done on the work bench.
With that said, I tore into a 700R4 a couple of years ago out of desperation to fix a problem. I bought a sweet 88 rag top camaro from a guy that had just gotten the trans rebuilt by a pro and just over the 90 day warranty it went south. You could start the car and put it in any gear you wanted but it did not move (bad pump).
I poor mouthed the price on the car, then poor mouthed a used pump and some other parts from a local trans shop. Yep, took it apart, slid the guts out, looked at them, shoved them back in with a rebuilt torque converter (said lots of prayers), and it worked like a champion. Turns out that the installer must have misaligned the torque converter into the pump cracking the torque converter shaft and smashing the pump. The car has been half way across the country several times since, and is coming back to rest in my garage again in May 02.
So, if Mr. Scared to work on a gear box can do it, I suppose anybody can. However, I still fear those things as I feel beyond lucky. On top of that, outside of my time I got that car up and running for $80. In negotiating with the prior owner I pointed out how it was going to cost me $1,500. So, as you can imagine I for once in my life got a good deal on something.