The 6BT (5.9L) Cummins (no "g" in Cummins) is quite a bit heavier than a big block, in the neighborhood of 400-500 lbs heavier.
Generally speaking, the newer the engine the more power it had from the factory. The 12 valves make more low end power and spool the turbo at a lower RPM, the 24 valves make more top end but need a couple hundred more RPM to get the turbo spooled.
89-93 is the first generation, they're easy and cheap to modify and can make good power. They're the most efficient of the 6 cylinder Cummins engines, partly because they have dynamic timing (like the mechanical advance in a SBC distributor). They're good to about 350hp/800-900ft.lbs. before you get into really expensive fuel supply mods.
The 94-98 12 valves can make more power because they have a healthier fuel supply, they are similarly easy to mod. They're not as efficient as the early motors but still good.
The Cummins actually fits pretty well into the old Chevy trucks. As far as efficiency is concerned, I don't think you'll do better than a 6.2L but there is so much more power available and it's a MUCH heavier duty engine. My truck (K30 with 37's, 4" lift) averages about 15 +/- just daily driving and exactly 20 on the highway driving 70 (averaged over the last 13,000 miles or so). I know it would do better at 60 but I would prefer to drive faster, my best tank was 25 mpg.