I've tried to explain for years how the trails in JV are about the same level of difficulty for the rig on 40's as it is for the rig on 35's. The smaller tires tend to be narrower width so they sneak right through places where the 40" tire rig has to put one tire on top of a 4 foot tall boulder and go over the top of it and try to get past without it putting you on your lid. Like you said, it is all relative and if there was a perfect wheelbase and tire size that worked everywhere, we'd all do it. Wheelbase and lots of it is fun until it isn't.
The width always seems to be the big hangup I see. I can definitely snake through narrow shit way easier