Coruscant... Venetors duking it out with separatist warships, fighters zipping by on strafing runs, it was a total hoot for me, quite the wild ride! Heck, I even love playing that stage in Lego Star Wars!
For non SW, Wrath of Khan and several of the B5 battles too, many of which are quite moving when taken in context of the stroyline, such as Gorash VII and the bombing of Narn, courtesy of Centauri mass drivers. I'm a laser beam-kinda guy, but I did enjoy the new Battlestar Galactica Battlestar vs Basestar scenes.