I'm not going to count games from genres I hate so no military competitive FPS, no RTS, no non-Mario Kart based racing games, or no non-arcadey sports games, etc.
Ocarina of Time - Before you think I am being a troll let me explain myself. I never had a N64 growing up and while I played plenty of it over at friends houses a Zelda game isn't exactly a two player game so I mostly played wrestling games, Mario Parties, and of course Golden Eye. My first 3D Zelda game was Wind Waker and I loved it so I'm not some jerk who thinks Zelda only works from an overhead perspective. The bonus for pre-ordering Wind Waker was getting a port of Ocarina of Time for the Game Cube and I just couldn't get into it. I tried again with the 3DS remake and while I finished it I just didn't see what all the fuss was about.
GTA IV - I love the GTA games but after San Andreas this felt like a step back for the franchise. The cars never felt quite right, the missions had little variety, the lack of shit to do outside of missions was disappointing, and fuck-off with people constantly calling you to see American titties. I also thought Niko made for a bad protagonist because given the story it made no sense to randomly murder pedestrians. I will say the two add-ons were really fun and had stuff that should have been in the game in the first place.