DQ 11 is also one of the only video games I've personally been hooked on the writing for, too. There are a few very emotional moments, both in the main story and side stories. Also, the rhyming mermaids start feeling corny but really grew on me.

Legend of Heroes is another.