If you want to talk about psychological journeys with large swords, I have two words for you:
Read "Berserk".
FF7? ....Nah. Aerith dying was one of the producer's way of getting revenge on the world for losing his mom.
Or at least, that would be MY reason for writing the plot that way.