I went down a similar path where I considered getting a pickup for hauling the occasional project material around. I ended up with a hatchback that covers 90% of use cases. The other 10% I can just rent a truck for a few hours to cover.

People pay double (or more) for gas every year so they can drive around an empty bed and maybe save $50 on a rental once a year.