You won't really gain a whole lot of HP even if you go with headers and fully new exhaust. Forced induction would be the way to go but there's no "bolt on" kits for the v8 so that would run you several thousand dollars of custom work and you'd have minimal support if you ran into issues.
You can do the long tube DT headers, replace the pinched y-pipe, and upgrade to a mild sounding muffler but that's gonna run you over a thousand dollars easily for barely more than 10% gain, if that. Or you can just buy a muffler for 100 bucks and be happy that you don't have a v6. The Dirty Deeds exhaust is a bit more expensive but everyone on here loves the sound of it, and zero drone.
IMO, it's only worth doing the headers if you have the common manifold cracks. When my manifold cracked I threw on the shorty DT headers and didn't notice much difference. I had the same HP dreams as you and ended up settling with the fact that these trucks are pigs. Apart from boosting the induction, you're not gonna make this a fast car. And even then you're driving a high center of gravity, poorly handling SUV.