Quite often, an indie game throws together some common gameplay, like roguelike shooter patterns, with little to explain it. eg, "You're here to explore for treasure!" Other times, even AAA games go this route, assuming most players won't care about the base story premise.
But there seems to be a significant contrast to well-developed worlds; like seeing the progressive cruelty of the Nazis in Wolfenstein before you start stabbing them, or seeing the Gommage in Expedition 33 before heading out to fight nevrons. Even more eldritch action-oriented games like DOOM benefited from establishing a "mood" of the Slayer being angry at demons and anyone who ignored warnings of them using just a few quick cutscenes.
This can be a bit of divergence from a game being "story-focused" or building up detailed lore. Some such games are often bad at motivation because the "story" is so confusing to players, most would just admit "I'm just going wherever bosses are to advance the story." Some very dialogue-heavy games don't necessarily captivate players on this level, since motivation can often be very simple. It goes back to the age-old strategy of arcade Donkey Kong; having 10 seconds at the beginning of the game where DK captures a princess who calls for help. The early version of the game likely didn't even have that, and the designer felt motivation was missing. (That decision spawned its own issue, the Damsel in Distress trope, but that's another topic)
As more conceptual ideas, and especially more perpetual live-service games, become more popular, I see this element of gaming going missing at all ranks of game development - which is a shame, because I think when written creatively, there are ways to set up player motivation through relatively few voice lines and short cutscenes; something going beyond "You are an amnesiac! This voice is telling you where to go. Don't die to The Corporation!!"
To drive discussion: What are some games you bounced off of, that you think may have been because they were missing motivation? What games found you putting up with a mediocre gameplay experience because you were invested in the given story turnout?

I made a similar argument about this a few days ago and got lambasted. I personally think payoff is important. As an adult I have a lot less time for games. To just “do” something when there are so many things to do and even other games to play has to mean something. Not just a “stat” boost. I don’t need another fetch quest. I don’t need a pointless collectible. If I’m doing something I want to be rewarded for it. A bit of lore actually acted out or even better yet new gameplay I didn’t have before.
I’m not saying an arcade type game can’t be fun or worth time. But that gameplay loop in itself has to feel rewarding to me. And in a growing list of games feeling the game the gameplay loop itself holds less value. As 10 of the last 15 releases on Steam have that same damn loop.
This is clearly a subjective thing but I’ll say personally I need to feel some intrinsic value for my time. And lately I haven’t been feeling reward. As a result I am playing less and less games these days ..