One game that instantly comes to mind for me is - Lost Patrol.
I mean, this game had a lot of potential and I love the setting... and it has great music, lovely still images and some really nice, slightly animated ones too (like the boat one).
Because of all of that, the game has a very good atmosphere and it could have been a brilliant game.
However, as it is, it feels very unfinished. The minigames feel unpolished and frustrating, and there are too few of them.
You're also given too few choices so you can't really pick all that many different strategies.
Finally, it's way too unfair... in fact I don't think I've ever finished it without cheating.