>>1452311this
also
1" road tyres
you can ride road tyres on forest trails fine I do it all the time. It's just technique and you can't slam them on and off drops. Let that give you some perspective.
1.25" cyclocross tyres
1.5"-1.75" hybrid tyres and gravel bike tyres
1.9"-2.2" old mtb standard
2.4-2.6" new mtb standard
This is what i'd suggest if you want something big. These are pretty big. Something like pic related.
2.8-3.0" 'plus' mtb
Imo even this is a dumb meme gimmick
3.0-5.0" fat bikes
mtbs also used to have 26" wheels and now they're larger, 27.5" or 29"