Jaw dropping gaming moments for me in addition to Rogue Leader would be Shenmue on dreamcast, Mario 64 on N64, Conker's Bad Fur Day on original xbox and the original Half Life on pc. For portables all I can think of is Little Big planet on psp, that looked amazing. I think for platforms that generally impressed overall for graphics it would be amiga and super nintendo where both delivered a huge upgrade in graphic quality across many games. Starfighter 3000 on Acorn Archimedes was very impressive for its time but I doubt many will know about that game. It was about the same time as Star Fox on super nintendo but had more open world environments, stages in asteroid fields and lots of scifi references including a battle with a starship enterprise look a like. Also you could change parameters so you could see your viewpoint and even the enemies viewpoint as you came in and blew it apart.
