"You Know My Name" is my hands-down favorite Bond opening of all time. It's just personal preference. I thought it much cooler than any of the others.
"View to a Kill," "Live and Let Die," "Goldeneye," "The World is Not Enough" and "Die Another Day" are my next favorites. All of them are great--I have a list with all of the Bond themes on my iPod, and they've made for great exercise music before.
I enjoyed that song, For your Eyes Only, by Sheena Easton is a nice one and You Know my Name, by Chris Cornell from Casino Royale is the one you're talking about? Got to be a rocker to enjoy that one I guess, lol.