My favourite is You Know My Name from Casino Royale. Absolute belter of a tune, and one of the best title sequences in the entire series. Daniel Kleinman out-did himself on that one.
A View To A Kill comes to mind next. I love Duran Duran and this tune also works very well when it's adapted for use throughout the film's score. I honestly don't get why so many people seem to hate it.
Another top pick would be Live And Let Die by Paul McCartney & Wings. Everyone loves this song, be honest.
"It's like Paul's song say: 'Live And Let Live'."
"Actually it was 'Live And Let Die'."
"Eh, whatever, whatever, it had a good rhythm."
Of course, there's always "Let the Sky-FURRRRRR! When it crum-BURRRRRR!"