xenosaga or xenogears ftw!!!!!!!! <----no story comes close
final fantasy X
Star Ocean 3..towards the end
Final Fantasy 8
Final Fantasy 9
FF Tactics