I just did this swap on my R2500 Suburban...
Did a monster in a box rebuild on a 700R4, used TCI’s constant pressure valve body and a stock converter. Have a nice cooler with a dedicated thermostat controlled fan.
It’s a nice transmission, and I’m sure it’ll last, but honestly I’m not as happy as I thought I’d be. I have 3.73s in the rear and it’s fine on the road, but still not where I want it.
I was in the same boat, happy with the 400 but wanted OD. If I could go back, building my 400 and adding a GV over/under would have been a better investment of time and money. It also would have forced my hand in going with a 1-piece DS immediately, but that’s another story. Anyway, you get all the awesomeness of the TH400, plus the stone cold reliability and capability of the GV over/under when you want it.
As it stands, my two-year plan is a 6L80, Allison 1K, or building another TH400 with a GV over/under once I decide on an engine.
But hey, I’ve always had standards in my GMs until this Suburban, so I was looking at the 700R4 from just a gearing point of view. I had never owned a vehicle with one. If you like the characteristics of the 700R4 in your camaro, match the rear end gearing in your pickup, and toss that 700 in there. They can be built to fix all the factory fails now for reasonable money.