1. Riddle of the Sphinx. I never understood how it was supposed to finish. It became so frustrating and confusing, I just no longer cared enough to beat it. Fun to play, not so fun to finish.

2. Punch-Out. OMG was it hard to run the gauntlet until the end. 100% earned.
2b. Knights of the Old Republic. Very replayable, too - same ending but fun to see the very different paths you could take to get there, especially with different abilities.
2c. Current game (well, more current than the other two, LOL) Red Dead Redemption. It had to end that way, though I didn't want it to at the time.

3. GTA series. Only because whenever I get to the end, I don't really want it to end. Plus, even though the endings have a "final boss" difficulty to them - you've already played and completed missions that have higher thrills/higher satisfaction prior to getting *to* the very end. I'd like to see them add unlockable missions after completing the game. Such as opening up flashback missions, side missions, non-main character missions, etc (like Episodes from Liberty City, but something you could earn rather than have to purchase.)
3b. Runner up - the original Halo. As the game got bigger and bigger, towards the end I felt the difficulty actually dropped. You became better equipped and the challenges became a numbers game - just more enemies thrown at you. I was surprised when I had completed the game. That was it?!?

I know you loved Last of Us. I did, too up until the ending. I disagreed with the character's forced decision. So - to me that was just as disappointing as LA Noire ending. I loved both aside from the endings, though - don't get me wrong. I thing both still are must-play/have games.

---