Oh man, I can think of so many games that are just absolutely horrid, but most of them are third party, so I can't list them.
But I'm going to file four games: Best Game Of All Time, Biggest Impression, Biggest Disappointment, and Worst Game Of All Time. All of them will be first party.
Best Game Of All Time: Super Mario Bros. 3
Many people have said it's also the best Mario game of all time as well, but seeing as it still stands as my favourite game even today, SMB3 is still one of those games you just pick up, play for hours on end, whether by yourself or with a friend (and kick his/her *** in the name of love x3), and the SNES version just made it better, with improved graphics, sound, music, and the ability to go back to World 1 before choosing the game. Nothing says kicking Bowser's *** multiple times than having a huge stock of 28 Whistles in your inventory. I had a hard time choosing between SMB3 and Zelda: Ocarina of Time.
Worst Game of All Time: Mariokart Wii
Now before you folks start coming at me with rakes, flaming torches and pitchforks, let me explain. Yes, Nintendo has a vast history of making good games, so it was quite tough to pick which first-party title sucked the most. In the end, I came to three choices: Pokémon Battle Revolution, Mariokart Wii, and Duck Hunt. I say Mariokart Wii, since I feel that this game was quickly rushed to the gaming market quicker than Sonic '06 (except Mariokart was complete, so HA), so what we got was generic Gamecube-like graphics, horrid voice acting, and crappy tracks. While we're able to play it on the Gamecube controller as an option, I still feel that Nintendo should've taken more time working on Mariokart Wii, and improve the VA's before its final release. Like I said, I had a very hard time trying to decide which game sucks the most for first party, and I can't say Hotel Mario, since it isn't on a Nintendo console, technically. For the record though, I do love the Mariokart games, but the Wii version, not so much.
Biggest Impression: Tetris DS
I'll be honest here, I was torn between Super Smash Bros. Melee and Tetris DS, deciding which game left the biggest impression on me, but in the end, I chose Tetris DS. Why? Well, despite it being the same Tetris game as it ever was, what was really cool about it is that it gave us some small throwbacks by tossing in some classic 8-bit sprites from the NES days. There are six game modes to choose from, each with different styles and challenges, plus it is one of the first Nintendo games (the very first was Mariokart DS, I know) that allowed you to play over Nintendo WFC, and challenging other Tetris players can be a lot of fun.
Biggest Disappointment: Metroid Prime Hunters
When I played the demo version, First Hunt, upon the release of the original Nintendo DS, I thought that this would be a great game to be added to the Metroid Prime roster. I was completely wrong. As a massive Metroid fan, I was very well let down with how bad the game is, in terms of gameplay, and playing online didn't help either, since almost everyone is a goddamn sniper, making me relive the Halo nightmares over again, which is why I refuse to play Halo 3 on Xbox Live. Metroid Prime Hunters, as nifty as the graphics are (and the commercial was amusing), it just sucks, plain and simple. You don't even get much of a chance to find out what the bosses' weaknesses are, since that alone is inherently vague.