Well, it wasn't the final boss battle, but the battle with Bowser at the end of World 1 in New SMB was great.
As for final boss battles, any of the Mario RPGs (including the one called Mario RPG) are my favorites, along with the boss for Mario Galaxy.
.. I have a really hard time picking favorites.