You are in a theater group and steal a magical princess. Yada Yada Yada, you find out your twin brother is using magic life mist to build an army of dolls... Yada Yada yada, the princess turns a castle into a giant robot to fight the doll army... Yada Yada yada, you go to your alien space ship to find all of your other clones, yada yada yada your clone brother kills you and the only way to realive is to kill Necron the god of death and then the game ends.
Final Fantasy 9, the pinnacle of FF games doing this.
Another favorite for me though would be Breath of Fire.
You are a man, you become a dragon man, you find out you were always a dragon, find the goddess and have to chose between killing her or becoming a dragon god and killing your friends.