The battle against Luca Blight in Suikoden II was a major one because of how epic it was.

Also if I listed all the moments from Zelda: A Link to the Past, Final Fantasy VI and Chrono Trigger that qualified here I'd probably never finish my post, but I will say that from the last of those, the whole 12,000 BC time frame was possibly my favourite part of the game.