Tire tread, rubber, gearing and rider skills still play a role. I'd recommend one that supports 26"/4.8" or 27.5"/4.5" tires for largest contact patch.

I never rode up dunes, and dines change constantly. So hard to predict if you could master them. But a good fattie with good tires at least gives you a fighting chance. You also want lower gearing. The lower the better.