I know what you mean. Last year I played the Metro 2033 remaster and it was refreshing having discreet levels that were not connected by an open world. The newest Metro game, naturally, has an open world...
That reminds me of how they made a Street Fighter game based on the movie based on the game. Despite being derived ultimately from a good game, the movie game was terrible, of course.
Costume Quest is great! It's a very lighthearted RPG from Double Fine and is about, of course, Halloween.
The Legendary Editions combine two of the normal Zelda manga books and look really snazzy. Definitely the way to go.
They had a couple issues where they jumped ahead to MMX for story reasons and then he was in the second crossover, but the comic was cancelled before they got back to him again 
I still listen to the music from this game sometimes.
At the time it was largely 2D action games I missed, I guess. These days we are drowning in excellent 2D indies (I just spent two weeks totally absorbed by Dead Cells, for instance) but 10-12 years ago it was much harder to get that fix.
We recently got a Switch Lite also and I really love it. We have some digital games but not a lot, so that's not really an issue. We don't really take our Switches out of the hourse either. Mainly we got it because my kids hog the main Switch most of the time and the Lite is for my wife and me.
The world was very bleak but the characters were really good, which balanced it away from being depressing.
...or at least that's the impression I got from seeing my wife play it lol.
I don't know of any but those games definitely came before the boom of game tie-in stuff of the last 10-15 years.
