Final Fantasy 7 - When Aeris was killed.
Lost Odyssey - Like Moana said, memories and stuff was very touching.
Final Fantasy 10 - Tidus and Auron at the end.