Zelda OoT. I've beaten it twice and I doubt I ever will again.

Resident Evil 4. I've gone into just why this game is terrible so many times on this board that I won't bother rehashing my feelings on it. Long story short, it's got more than it's fair share of flaws that suck anything resembling fun out of the game.