So far it's been a fairly good experience with 700R and its electronics 4L60E sibling. My 93 S10 TBI 4.3 V6 4L60, developed bad front seal and had to keep adding quarts but it kept going and yet at about 24 mpg highway before replacement. Found out later front pump seal leak is very common.
My 91 G20 Van 350 TBI with GM Goodwrench 700R, I put 30,000 miles towing with full size car trailer midsize and full size cars and no issues. I just drove it off the tachometer kept it 2200 to no more than 2500 RPM and just stayed in the far right lane.
Got any where from 20 to 25 MPG, but did have some unusual trips with higher mileage. I never had any issues, obvious previous owner did as it had a GM replacement.
Put a 700R in 64 Ford F100 for a customer, no issues. Put a 2004R for another customer, 87
Caprice with a 4 Bolt 350, no issues. Several other builds with no issues.
I had a 2004R on display at friends shop in Tucson, when a customer called me one day with bad trans on their show car when I was out of town. I told him go to the shop and install the one on display. Yeah, he called me about a week later telling me that the trans was no good. And yeah, the installer didn't hook up the "Kick down cable". Yep, trans was junk now. Folks, it's not a kick down cable.... But pulled it built another one for him and no issues.
Most your trans guys today are good at building stock and this day and age few know how to improve what's there. This is true for Chrysler 518/618, Ford C4/C6 or AOD, or GM 200, 350, 400, 2004R, 700R, etc...
700R4 minimum any build is 13 vane pump, .500 boost valve, Teflon Rings, Sonnex Sun Shell, wide band, and Corvette Servo.
You can further improve by changing bushings to bearings, make sure end play is correct, cut pistons down to add another clutch, add extra cooling, and hardened or billet parts.