Here we go again....
The 6.2/6.5 engine is usually "okay" if you accept it for what it is.
If you're looking for an acceptable street driver that is good on fuel, ask your doctor if 6.2 is right for you. If you're looking for reasonable towing power (not Duramax or Powerstroke power) it could be acceptable.
If you want to go racing, forget it. If you want to enter a tractor pull. Forget it.
They will tolerate a modest amount of turbocharging. Don't expect it to be reliable beyond 200HP. They have notoriously weak bottom ends and the main webs tend to crack, leading to broken crankshafts.
However, if you keep it in perspective and don't do anything foolish, they have a reputation in fleets for being a reliable 300K mile engine.
Alternatives:
Most people opt for the 6B. I'm not a fan in this application although will readily admit they are generally excellent engines. If only they didn't sound like a bucket of bolts.
A 4B from a step van = "P" van gives comparable performance to a 6.2 and has a flywheel and housing that bolts to a THM400 or 4L80E.
I've always been intrigued by the 5.0L V-8 Cummins that Nissan used in their pickups, but I've not heard great things about them.
Any choice you make, except possibly the 5.0L, an overdrive transmission is recommended so you can use low gear ratios to gain the pulling power and acceleration, while getting decent mileage and not having to listen to those things scream. The Cummins in particular have a low RPM range and power band that makes them much less streetable without some gear splitting.