So reading this thread I'm thinking, it's really all about what kind of gravel surface you are presented with that drives your experience and what kind of bike and tire would work best.
Net search turned up this:
https://www.bikeradar.com/features/4-types-of-gravel-2-types-of-fun/
Takeaways:
"Neil Shirley put together this list on the four types of gravel, half-jokingly calling it ISGG, for
International Standard Guide to Gravel.
Category 1 gravel: Smooth, well-maintained dirt roads with little to no small gravel chunks
- Ideal bike: Road bike
- Tire size: 25-28mm
- Event examples: Haute Route Rockies, Battenkill Roubaix
Category 2 gravel: Dirt roads with potholes, washboards and loose corners
- Ideal bike: Endurance road bike
- Tire size: 28-32mm
- Event examples: Gravel Worlds, Dirty Devil, Boulder Roubaix, Belgian Waffle Ride, Grapes Of Wrath
Category 3 gravel: Poorly maintained roads with bigger rocks, ruts and/or sand
- Ideal bike: Gravel bike
- Tire size: 33-38mm
- Event examples: Rebecca’s Private Idaho, Landrun 100, Crusher In The Tushar, Rock Cobbler, Gravel MOB, SPNDX Stampede, Chino Grinder
Category 4 gravel: Non-maintained tracks or roads with deep layers of sharp gravel
- Ideal bike: Gravel bike
- Tire size: 38-42+mm, or Road Plus (650b wheels with 42+mm tires)
- Event examples: Dirty Kanza, Grinduro, Lost and Found"
Nick Legan's two types of fun.
Type 1 fun: Present-tense enjoyment; what most of us mean when we say ‘fun’
- Enjoying a ripping descent, watching a good comedy
Type 2 fun: Retrospective enjoyment — but often a little grim at the time
- Surviving a grueling challenge, enduring an embarrassing-at-the-time but funny-later saga
“I’m not sure where I first heard of Type 2 fun, but it was an idea that instantly appealed to me. It helped explain why I liked some of the things I like. The long rides, the hard rides, the hike-a-bikes, battling headwinds for hours, winter overnighters.
“The most important aspect of Type 2 fun is that it’s the only kind that can be transformative,” he said. “Type 1 fun doesn’t challenge you. It doesn’t force you to adjust your perspective on a situation in which you find yourself. Ideally, sport and physical endeavors are about growth, both physical and mental, sometimes even spiritual.”
“The only potential pitfall is that you don’t deal with Type 2 fun well and it shifts into misery,” he said. “Suffering and misery don’t need to be elevated or romanticized. They suck. Floating in the middle of Type 1 and misery is the key.”
Pretty cool article.