Absolutely Mother 3.
The game STARTS with the main character's spoiler And it just gets worse from there.
spoiler
But then comes the ending. Good God, that ending. spoiler
So yeah, Mother 3.