TLDR: if you want to do sand and mud but keep road performance I would get the lowest RR knobby tire you can find and keep it reasonably narrow to limit the aerodynamic penalty. Something like the Continental Terra Speed in 35mm, if you can make that work comfort wise.
Anyway, one of my quarantine projects has been trying to figure out how to "test" different tires and tire widths on gravel. And it's basically been a shitshow of meaningless data, but there were some unexpected observations. I believe the following at this point:
My personal experience is also that knobs matter more than width when going through short runs of mud, but don't feel as good on regular gravel. Also, no gravel tire I tried comes close to a GP5000 TL road tire.