@rruff - the bike tire findings you mention are interesting, and I have no doubt are true — my racing days ended about 12 years ago after a bad crash, so I’m a bit out of date.
I was attempting to make a practical generalization for the OP, maybe not the best analogy for overland trucks, but — kinda dont want to leave him with conflicting notions regarding his original wheelbase/tire size/mpg questions.
There are certainly so many complicating factors that its hard to pinpoint one thing, but it sure seems that tire size and weight changes affect both performance and mileage. Sure, so does tire design and compounds, PSI, driving style, aerodynamics, gear ratios and truck model, among other things too.
I don’t for a minute doubt your personal experience with tire size, but would you agree that the majority of people you know or whom you have interacted with on forums who go to larger, heavier, more aggressive off road tires without expensive regearing, tend to find they hurt their mileage in most cases? That’s overwhelmingly been my experience, as well as personally over 5 different vehicles.
For the OP — I think there’s a sweet spot if you want to travel in full size truck on the highway and then wheel it moderately to even heavily: The shortest wheel base you can handle for your needs (eg, camper, towing, payload needs, daily driver for work, etc), some lift to match your style of off roading (more if you want to rock crawl), better/larger/tougher tires without over or under doing the weight or size for your truck’s gearing, your anticipated payload, and style of off-road.
You might also want to play with a gearing calculator just to see how tire size affects your rpms at different speeds and potentially your mpg, though as you can see from
@rruff ’s and my posts, there’s a lot of variables. This is a pretty good one: