Dancing Mad is the absolute peak. Other strong entries are The Extreme (FFVIII), Highbrow (Star Ocean 3), and The Sacrifice Part III (Seiken Densetsu 3). Other examples of near-final battles that are cool are World Revolution as already mentioned (Chrono Trigger), Dark Messenger (FFIX), Dragon God (Chrono Cross), and The Sorcerer (Secret of Mana). All of these games also have cool final battle themes (except Chrono Cross whose final battle doesn't actually have music) but the penultimate battle themes are cooler.

One-Winged Angel was cool at one point but got ruined from overexposure.