1. Spore. I has such high expectations of this game. The first part (till you get to build stuff) was completely and totally awesome. From that point on, I didn't even bother playing it.
2. Nier. Tried so many times to beat this game, but I always get bored and give up. Not believing you guys again.
3. Enslaved: Odysee to the west. Man was the this game awesome for the most part. Then it became repetitive. The combat is great, the characters are great, the voice acting is awesome. The enemies are uninspiring and I got bored quite a few times while playing it. Never managed to finish it.
I'm sure there are more, but these ones had tremendous potential, which was waste.
edit: Almost forgot the most important ones:
4. Wii sports. Such a great game for the first 15 hours and then it gets terrible. I'm glad Sports Champions improved upon it. Great concept by all means and the way I wish games and the game industry would head (I know les hardorez hate it though).
5. WiiFit: Can't express how disappointed I was in this game. Don't know what I expected, but what I do know is that it was by all means a massive waste of money (paid more than 100 euro for it).