Two examples of heavy vehicles that (can) get good mileage:
1. 1992 Buick Roadmaster. 350 cid engine, 4 speed auto (really 3+overdrive). Low 20's highway (average), 24-25 attainable if you can keep your foot out of it. 1700rpm at 70 mph.
2. 2002 Chevy Suburban, 6000cc engine, 2500HD. Easily obtains low 20's on the highway, 25 is doable if you can keep your foot out of it. Not sure of the transmission.
Compare that to my 2002 Honda Accord V6. 3000cc, 24-25 mpg average, 30-31 maximum.
Best mileage ever: 72 mpg. 1989 Honda VTR 250.
Worse mileage ever: 8 mpg. 1978 Ford 3/4 ton "Camper Special", 400cid with the auto. It had 2 gas tanks and it needed 'em.