LittleBigPlanet, I just found it to be boring. Plus whenever I played it with my sister she would get mad when I slapped her in the game lol.
The Lego games. I liked them years ago but just find the formula to be really boring after about 3 games. The pick up and use what's lying around combat system in Lego Indiana Jones 2 was absolutely terrible too. All of the vehicle levels after the first Lego game (Lego Star Wars) were just subpar as well.

I wouldn't say I actively disliked it necessarily, but Vanquish wasn't that fun for me. Again, super quick arcadey Platinum games shooter did not ever need tons of uninteresting cutscenes and a cover system.

I hate these kinds of topics, just wanted to put that out there.

...oh, alright, I'll be on topic:

Half-Life 2 - One word: Ravenholm.
Final Fantasy VI - It's way too easy, the story sucks, I hate the characters (especially Kefka), and there's way too many mini-games.
Super Mario World - This game can die in a hole.
Goldeneye 007 (N64) - It's pretty much unplayable now.

That's all that I still care enough to remember.

Skyward Sword. You say innovative motion controls, I say dumb gimmick after dumb gimmick.

People liked Skyward Sword? That's news to me.

Comparing the controls to just pushing a button, I think it was a nice stress reliever.

I'll agree with the OP, and say LittleBigPlanet. I found it's gameplay to be nothing special, and it's art style to be slightly more creepy than cute. I got it free through the Welcome Back program, so I guess I can't complain, though.

I never liked LittleBigPlanet either. The lighting was too dark in some places and I just didn't find the gameplay fun. From what I played of Uncharted 3, I didn't enjoy. I'm not a fan of the whole third-person cover shooter thing and it was just kinda dull.
The original Legend of Zelda has ages poorly in my eyes and I found fighting enemies and wandering the overworld a chore, I prefer Zelda II myself.

Starfox Adventures, and that was before it broke my wii. Everybody says it's underrated, yet in every NL article about it, the comment sections of it is filled with blind love for reimagining of things, regardless of how horrible the game is. -_-

I enjoyed Star Fox Adventures, but it definitely had a lot of problems, mostly due to its development changes and whatnot.

River City Ransom, Alex Kidd in MIracle World, and Magician Lord
I just want to point out, I don't hate these games, but I certainly did not find myself thinking they were fantastic either

Pokemon Diamond & Pearl.
Yeah, it was a horrible generation. Nothing new, meh story, meh new little mon's to capture. But a lot of people liked it.

Tales of the Abyss 3DS:Just found it to be boring and the characters really annoyed the hell out of me.
Metal Gear Series:I don't mind the gameplay but the characters and story just make me want to roll my eyes.

This is exactly why I hate the 5th gen.

THEY MADE AN ICE CREAM CONE A POKEMON!

And the supposedly "amazing" stories in both were worthless and bland in my eyes. A basic story is better than a bad story.

All of the Zelda games, except for WindWaker. They just bore me to tears.

Also, Super Mario 3D Land. Not a bad game, but definitely the worst Mario game ever. It's so easy and derivative.

Mario and Luigi Bowsers Inside Story. I don't know why, but when I first got it I just hated it, however after Nintendo Power, (they had an awesome preview for it the August 2009 issue) on their top 285 Nintendo games ever (last issue) they ranked it highly so I am finally getting around to replaying it. So it might not count soon enough.

@WesCash - really, that [reasons you stated] makes it the worst Mario for you? I don't mind so much that it was easy (but there were definitely some challenging moments on there, and it's a big challenge when it comes to completing the game), and I personally never found it to be "derivative". I'm sorry that you didn't like Super Mario 3D Land, but hey, different strokes for different folks, right? Pardon my reaction, but this is the first time I've heard someone put Super Mario 3D Land and "Worst Mario" in the same sentence

Another vote for LittleBigPlanet. That is one of the most boring, dull, lifeless games I've ever played. I still can't believe the Academy of Interactive Arts and Sciences awarded it Game of the Year 2008.

I'll add Okami to this list. The graphics are gorgeous, but the gameplay and story just left me bored, uninterested, lost, and confused. That's one of the very, very few games I bought but didn't finish. I played it for 20 hours or so, and kept thinking, "It's gotta pick up soon, right?" I've never waited for a game to "get good" for so long (and it never did, in my opinion). Maybe I was just disappointed because the game seemed like it had a lot of untapped potential. But it seems to me that If it wasn't such a beautiful game, I don't think anybody would have payed it much attention.

Grand Theft Auto IV. Possibly the most critically overrated game ever. Not a bad game, really, but it just made me miss the days of GTA III and Vice City. Back when the series was actually fun to play and didn't strive for an overly poignant story. It seems like Rockstar was trying to win an Academy Award instead of just making a fun game.

Most shooters, racers (including every F-Zero and most Mario Karts) and action games and several "classic" games.

Pushmo and Sakura Samurai.

Wario Land II and 4 and Kirby's Dream Land.

I'm sure there's more but I can't remember them all. (why would I?)