I kind of covered that here where I said that I wondered if it was me, but then while revisiting older games I love, I realised it isn't true. It's just that most games now are just boring, and that's why we can't keep our attention.
Things go in decline with so many things. I bet all those story writers for games should revisit Robert McKee' "Story", then they would know how to make things engaging and interesting for all players.
I guess the problem also comes from the cryptic kind of storytelling games like Demon Souls and everything soulslike have brought to the gaming industry. But even those games know how to get people into piecing together the lore of the game and the story.
I've always loved how most of the Fallout games were able to tell stories without words, with how locations looked, or how the things were placed around rooms.
Yup, even the first ones with the DnD grids did a great job in storytelling.