That's just one of those love it or hate it situations, pure opinion. Like, in the gaming world there's games that are universally bad/good (or just bad fun) but games like Assassin's creed is ether you don't mind doing the same pattern in different ways over and over again (i.e. me) or you find it repetetive and utterly boring. The same goes for No More Heroes, which I like as well.
Good in the fun part, anyway. Some games are just plain designed badly, have bad presentation, dialogue, (gulp) music, you know, presentation and whatnot. That's sort've what we're talking about here. Ninja Gaiden is bad in almost all of the things above, but the gameplay is so amazing that everything else doesn't matter; it sort've adds to the charm of it, really. Then there's Legacy of Kain: The combat and gameplay are mediocre, but the story and dialogue are great. (or at least out of what my friends showed/told me)