Alan Silvestri's synth-heavy driving melodies for Flight of the Navigator
http://www.youtube.com/watch?v=Hl8XoRLrTmE
"Robot Romp" is my favourite track simply for those middle 8 minor chords
http://www.youtube.com/watch?v=64LylkvToVU (3:28 in)
Also "Short Circuit" had an awesome closing theme : "Come and Follow Me" by Max Carl and Marcy Levy
http://www.youtube.com/watch?v=F1aTuVMFlMI
Best Bond Theme? Nobody Does It Better. However, for sheer impact, "You Know My Name" for Casino Royale worked awesomely.
Nothing beats John Williams. I can listen to ET, Jaws and Jurassic Park all day.
Honourable mention also to Howard Shore's eerie guitar-led theme for "Crash"
http://www.youtube.com/watch?v=6Otjw30JLhg