To be honest I've never understood how a game can be "good" if it's that bad. If I dislike a game a lot I'll simply never think it's good "because it's bad". There are some games, however, that I have to sort of "tolerate" when I play them, but they're not so bad as to categorize them as "so bad it's good".
I suppose one game that immediately comes to mind is Star Wars: The Force Unleashed (first one). The PC version's GUI is a travesty and an insult, it's just terribad (that means it's so terrible it's actually bad, probably is so for one's sanity). I had to Force myself (yeah... I'm trying with puns lately, not a bad one huh?) to play it (and to navigate through that nightmare of a GUI, that's excluding actually pretty bad controls overall) but I actually enjoyed it for its story, decent-to-excellent voice acting (Darth Vader's voice actor's performance is absolutely incredible), well done scripted scenes, and... dare I say it... Quick Time Events that I managed to appreciate.
It's the type of game that has just a couple of horribly-implemented elements and features that in and of themselves can definitely act like a solid wall you'd hit at a thousand miles an hour; you either stop right there when you notice it or you continue through it with the inevitable pain that must go with it. I chose to just "play it anyway", but not because the game itself (overall) was "bad", it was in fact good. But if I had to score the game I would actually have to isolate or simply ignore (or remove) the game's GUI and controls in order to even consider scoring it to begin with (but at the same time, it's "part of" the game, so the score would end up low, even if I actually enjoyed the "core" game).
I do believe, however, that there is one game that might fall into a category that I would have to name "I was so dumb at the time for actually liking it", namely The Peacekeepers on the SNES. In retrospect I have nothing but negatives for it, yet I must have rented it a good 5+ times back then and even enjoyed it (genuinely so) especially when I played co-op with my friends and cousin. It's not actually "good", it's just a horrible game, but at the time I was so blind about it... not sure why. I was young and dumb: the only possible explanation I can come up with.