It Depends, like everyone says. My scandal had just an 11-36, because it weighed nothing, had fast tyres and while it did some long days- GT7 frinstance- it’s usually not on really bad ground. Whereas my trailfox got an 11-42 because it’s heavier, it’s got proper fat knobbly tyres, and it’s the bike I use for grinding out bigger mountain rides etc. It’s also the one that gets pedalled faster so I can’t lose the top gears to add lower.
I’m reasonably strong tbh but there’s a limit there- people say “I can get up anything with gearing X” but it’s not just this one climb you need to get up, sometimes working hard in a higher gear grinds you down a bit too fast over several hours.
Also, you can always gear down the front but then maybe you run out of higher gears too.