If you browse PT.net, you will find that the NP246 (rpo NP8 autoTrak with 4-mode selection) is perfectly capable of transferring almost any amount of power that is put through it. Guys launch 4wd, built & supercharged motors on the stocker case behind the 4L80e. Trying to upgrade from any of the stock, v8 T-cases would be a waste of time & money. Even the AWD case that comes on a lot of the Denali & Escalde models go on to move 800+ HP in factory form, the same version albeit differently splined input gears, behind both the 4L60 & 80e.
The 4L60 transmission is probably going to be the weakest link on the 800-platform, far as survivability of abuse and transfer of power. I would bet the trans' (rpo M30) quits long before the rear diff, purely based on testimonials and threads found on the net as I stopped putting my vehicles through the ringer a long time ago.
The NP 243 does have 1 outstanding design flaw that is easily corrected with a cheap kit, all in regard to the factory oil pump design. The fix entails nothing more than splitting the case halves, removing a large clip, remove & replace the oil pump spacer, seal case halves and reverse the disassembly procedure. Inspect and replace the output bearings and oil seals while the case is on your bench.