I may be alone in this, but lufia 2's ending was pretty... emotional for me. Simply because of how devoted maxim is, and how unlike any other hero, he was always confident, sure, and strong. And in the end, he sees his beloved die, and rather than giving up, he saves his home from being destroyed at the cost of his life. Then all of his friends wait for him to come home, because knowing maxim, they expect him to pull through like he always does, but this is the one time where he doesn't come back.
The DS remake of it, was kinda sad as well, but it just didn't have the same... emotion at the final scene... great game though