I would say 99% of the time if the game took 100+h to play and was a story focused game then it was a waste of time. BG3 is an exception here. From a quick search, RDR2 takes 50h and it isn't a short game. Would you watch a 100+h movie? Of course not. There's almost no way a well told story is taking that long, unless it's some kind of Immersive experience or something.

That said, plenty of non-story games will take much longer. If the focus is good gameplay, there's a near limitless amount of time it can take. If there's story interwoven, it could take any amount of time. I've put far more than 100h into a ton of indie games that do interesting things with their gameplay. You just don't see that experimentation coming from the AAA space normally because it's not guaranteed profit.