Not sure how many people ever played The Longest Journey or Dreamfall, but Dreamfall had an ending that made Shenmue II look good. I gave up on ever seeing an end to it, but it looks like they are going to bring an end to the story after all. It gives me hope that we'll see Shenmue III someday.
Dreamfall had the worst fighting I've ever seen in a game, though.
Dreamfall: Chapters info
Here's some info on the past games.