I would have to agree on Fire Emblem Awakening. That was a brilliant story, and I loved the ending.
I feel sad whenever I get to the end of a game/book/show with a great, captivating story. Kind of like a "Wow, what do I do with my life after that?!" feeling. But as far as games go, Zelda...