I'll pull out my standard go to terrible game: Mission Impossible on the N64. By every conceivable objective measure I can think of it is a game of good ideas and god awful execution. Almost nothing in this title is well done except maybe the embassy mission. But I still love it and have a blast playing through it whenever I pick it up.