I thought you were comparing games to movies and books. Not other games.
I loved the Zelda games. Haven't played on since Ocarina of time though.
I stand corrected......
Well, personally, I feel that comparing the vast majority of game writing to well written books and films isn't even worth doing at this point. The art of writing for games is just still too undeveloped, I guess.
Zelda games are generally awesome and all but they are not RPGs. Besides, the writing in the Zelda games was just a very basic background to get the gameplay going. The writing in those games was just functional, and best if ignored.
Finally, regarding The Longest Journey, I don't think it was a particularly good game, in the sense that its core gameplay mechanics just weren't very good. What I think The Longest Journey did well was the writing, as its character development was comparatively rich and engaging and its plot development did a very good job of keeping the player engaged. I think TLJ is one of only a handful of games where the writing managed to make its characters feel like real people and not just a collection of standard archetypes.