My top 3 Bond songs are as follows:
1. You Only Live Twice. It's such a pretty song. I have no idea what the lyrics mean, but they sound good. Which is better than a lot of songs nowadays where you can't tell what they're talking about and the lyrics sound terrible. YOLT, as I like to call it (Well, I don't really like to call it that, but it's easier than typing the whole title out), also happens to be my favorite Connery Bond movie. It's so cheesy, and largely improbable, and Roald Dahl (who wrote the script), God love him, obviously knew less about the Space Program than the dogs the Russians sent up in their space capsules, but the whole movie was done in such a dignified way. And let's face it, the crater interior set was cool as hell.
2. You Know My Name from Casino Royale. I can't help it. It's just so catchy. And unlike many of the Bond theme songs, the lyrics actually seem to mean something. At least, I think I understand them. It seems to be written from Bond's perspective, and it's about Vesper. It's basically saying
you're going to die, and there's nothing I can do to prevent it, so I'll try to forget you.
And it's true that the main Bond theme doesn't appear in its full form until the end of the movie, but if you listen closely, you can hear hints of it throughout the score.
3. A View To A Kill. All the awesomeness of a Duran Duran song with the scope and scale and bombast of a Bond theme. Need I say more? Incidentally, has anyone ever seen the video for A View To A Kill that was made using clips from the Legend Of Zelda: Majora's Mask? It's quite amusing, especially if you've played the game. Here's a link (no pun intended) to it:
http://www.youtube.com/watch?v=scpneag17Vs