Route

mediocre trash

masterpiece

I didn't know that games are divided into only these two categories.

What will future generations remember?

It's too early to judge. But old games, Hero, are often remembered not because they are so amazing now, but because they helped shape the genre or brought something new to it. By modern standards, many of these "masterpieces" are now inferior to "mediocre trash." Because genres evolve, yes. And the demands on games are growing. It is unlikely that anyone, except for people who experienced the first Civilization or early Ultima games, plays them much anymore, and yet these are cult games. And even less likely that any new players will be able to appreciate them.
But if you need examples of games with an active fan base that remembers and loves them, you can recall the third Witcher, for example. You can't deny that it has a huge community that has spread everywhere, right? You go to the discussion of an upcoming game on Steam, and there are fans explaining why this game is a hundred times worse, even though it hasn't even been released yet. You can also recall games like Last of Us or Evil Within, the sequels of which are eagerly awaited by fans. Or maybe you need worthy continuations of old series? After all, Doom was recently released, which was liked by the vast majority of old-school fans! Or the seventh Resident Evil, which was warmly received by fans of the series. And we shouldn't forget about the fifth MGS...
As for bad games, they have always existed. It's just that many people have already forgotten about old bad games. And now there are simply more games being released, as the industry has developed significantly in the last couple of decades.