I think the game should have oilsand as a late game local oil source.

Then the mega trucks can be right in their element and some new production lines can be made.

Cool idea, oil sands require significant addition of water for processing compared with more accessible sources of oil, an additional byproduct could be the separated sand and wastewater. The additional work involved would mean getting at the resource would be much more of a challenge than a pump.