I don’t think I could pin down a universal number. I really enjoy when a game understands the staying power of its gameplay loop and finishes up before it gets stale.
I’ve got 180 hours into TotK and I’m not sick of it yet because I discover something new every time I play.
Conversely I 100%-ed Dredge in 20 hours and that felt like the exact right amount of time. Any longer and I’d have been sick of it.
Or we can go even lower with something like Untitled Goose Game, which was under 10 hours and also finished up just as it got old.
So yeah. I’m all about the self awareness of a game with regards to the experience. Whatever amount of time that takes is cool with me.