I have played too many adventure games with weak endings. What's the deal with some developers? They should hire proper writers!

Sorry Phoebe, I have to disagree totally with Scratches. That game's ending was too confusing and abrupt for my taste.

Some recent games I played have great endings. They are not adventure games, but there are some adventure game elements in them:

Bookworm Adventures - Casual GameThe developers did an incredible, breakthrough job making a word spelling game into an RPG complete with experience levelling, monsters, ability enhancing inventory items, monsters, bosses and a great story with at least two twists in the game and a great ending.

Onimusha 3 - Button meshing action gameEndorsed and starring two major actors, this Japanese action game had the gamer switching between the two major characters in different time periods to solve puzzles together. There were twists and surprises and easter eggs for the ending.

My favorite is probably Syberia. I think it's the only time where I had a true emotional reaction during the final cutcene of a game. I remember the first time I played it being so stressed whether she would catch that train!

I also thought the ending of Paradise was a real gut punch (though I didn't think the entire game itself was so fabulous). That ending is probably the most haunting of any game I've played, it really stayed with me after the end of the game.