On major reason why the 6.2L is not in the HD trucks is because it has an aluminum block which is not ideal for a gasoline HD truck. Cars like the the ZL1 is meant for the track. Not the one that goes in a strait line, the one that has turns and is constantly shifting up and down gears creating heat.
Going back to GM Authorities 6L90 spec sheet, the "maximum validated GVW" is 15,000 lbs and the max GCVW is 21,000 lbs.
Heat in a transmission is usually generally from slippage and/or constant high line pressure. If the 6L90's torque converter is locked and has enough clamping force to handle the amount of power and weight that a tuned 6.0L is rated for then there will be no slippage. Most transmissions that fail from added power is due to slippage, but as stated in the spec sheet, the 6L90 is rated to handle way more than what just a tune will do to a 6.0L even in a truck application.
The valve body line pressure is depended your right foot and engine load so it will get hot under constant high load with added power or not if the trans cooler cannot keep it in check. Added power has nothing to do with this heat and in fact added power may even help if the engine does not have to be at such a high load as often.
However, this is why tuners have tow tunes and unloaded tunes. Tow tuned generally have lower power numbers and alters shifting to be at optimum rpms with firmer shifts. Firmer shifts are to keep slippage between shifts at a minimum which reduces heat. Unloaded tunes generally have higher power numbers while keeping the buttery smooth shifts(more slippage) from the factory. So you select the tune and customize it based on how you will using your truck instead of being forced to drive a one size fits all tune made for applications/situations you will probably never drive your truck in.