The only ones i like are Tomorrow never dies and Goldeneye. The rest are kind of sub-par songs that do their best to fit in with the bond feeling.
I think TND and GE smash it right out of the park. I still to this day listen to each once a week at least.
Tomorrow never dies especially, i think that is the single best vocal performance sheryl crow will ever do. I dont like her normal songs, im not a fan of hers. But that shit suprised me, in a good way. Saw the movie in the cinema, and i remember the audience kinda didnt get it i think. The predominantly male driven notion was "fuck off with this music, where is bond killing things" - but it got to me pretty hardcore.
Ten years does a lot of things though, I mean compare the artistry of bono/edge writing + tina turner singing, with chris cornell butt raping james bond into this weird thing. Its a clear sign the traditions of bond are long over, since you just know bono wanted to sing his own lyrics with tina (maybe a chorus duet) but he just knew there was fuck all chance that would fly.
I remember when that chris cornell song came on I just felt so uneasy through the whole start credits (no offence to those who liked it), it took me right out of the notion this was a bond film, i remember thinking "why, why did they do this". It was an epic moment when the movie started and completely turned me around almost instantly. Thats the brilliance of martin campbell.