Ianus

I never thought of the Titanic theme when I heard this at VGMix, but now that people have mentioned it, I hear some similarities. I think Destiny's piece is much better, of course: more overall goodness + less Dion factor = totally solid. It's the music that plays during the cutscene with the mana stones that plays before your hero takes the sword. It's also played briefly (and cut short, I might add) during the ending.