Aaaaaah so many good ones to choose from!
I like many that were already mentioned: &guy, diamonds are forever, live and let die, goldeneye by Tina Turner,
But surprisingly the two recent movie themes were pretty good too
And honorable mention if you ever played the Bond game Bloodstone on PC, xbox or playstation, the theme for that is really good, by Joss stone. Game was good too but frustrating at times.