I might throw in a suggestion I haven’t seen offered yet. You say you like the CRV, I have one too, and it is for my purposes, a fantastic auto. I do agree though, sometimes I could use a bit more room. My wife’s daily driver is a 2013 Toyota Highlander, and I think it is the best car we have ever owned, and we have had a lot of them. Both of theses cars have a bit under 100k on them, and have never had a thing go wrong in them.
The Highlander, has more storage, capable AWD function, better than the CRV, is heavier, quieter, and more comfortable on long trips. She consistently gets 20 mpg around town, and a bit better on the open road.
Another feature you might need is the security of having your tools and electronics locked up and out of the weather. I’m pretty sure this is a 300k car, and a good used model wouldn’t be excessively expensive, no where near a new diesel pu.