Story based motivators mean almost nothing to me, esspecially when told through non-gameplay means. Having an "intro" cutscene is almost akin to a text crawl/card in a movie - technically it works, and it can be an efficient way to give extra context, but its also likely to disrupt pacing or disorient - basically makes me want to watch less, rather than more. In the same way, I can't think of any games where story played a significant part in motivation to continue. If I want to keep playing, its because the game is good, not because it told me I should.
Edit: Maybe to help clairify, good plot can be a motivator, but the character's motivation is not my motivation. Whats important is that the plot is good, not that the protagonist's goal is just.
It feels like there has been some dropoff, particularly in higher-budget areas. Big studios seem to be taking fewer risks, and small creators have less money (and time by extention) to spend on art.
That said, it also feels like discoverability has gotten far worse. Social media has become increasingly insular, more personalized, more algorighmic, and ultimately harder to explore. Its not like the old days, where you could find a new thing, even from a random person's forum signature.