Honestly, very few come to mind.
FF9 came first, for being consistent, clear, and having complex, yet fun. The world is realized, the dialogue is good, and even the final boss has relevance if you understand thematic stuff.
Chrono Cross was another one. Sometimes it is almost poetic. And no, I dont have a problem with how it handled CT. I appreciate the direction, I felt it when we realized what went down, and it made it more heartbreaking.
The only other ones I can think of are VNs, which really shouldnt count. But Hotel Dusk and the sequel popped into my head.
Recently, I played Mad Rat Dead. While the dialogue isnt special, the themes are kind of a rare thing to see in games, or any story. A story about a
rat who swears revenge on a scientist who experimented on him, after the Rat God gives him one more day to correct any wrongs he feels. He eventually comes to terms that not only is revenge was driving him mad, and that life is about the journey and not the destination, but he even goes as far as trying to understand the scientist, because he learns how to communicate instead of just acting on his feelings.
I really appreciated the character development from such an unexpected place.
ORAS secret base: http://imgur.com/V9nAVrd
3DS friend code: 0173-1465-1236