So, here's my ranking:
1. Goldfinger
2. The World is not enough
3. Surrender
4. You know my Name
5. Nobody does it better
6. GoldenEye
7. Thunderball
8. From Russia with Love
9. Live and let Die
10. The Man with the Golden Gun
11. Diamonds are Forever
12. You only live twice
13. A View to a Kill
14. The living Daylights
15. Tomorrow never dies
16. Moonraker
17. Licence to Kill
18. Another Way to Die
19. Where has Everybody gone
20. Mr. Kiss Kiss Bang Bang
21. For your Eyes only*
22. All the Time in the World*
23. All-time high*
24. Die another Day
Liked those songs, but they didn't had the right dramatic tone necessary for a really good Bond song.
I also like some of the songs that were in the running to be the official theme, but were ultimately rejected. Some of those are even better than the ones they did use. Of those I could get my ears on, here're my categories.
Really good ones, better than what they ended up using:
- Eva Almer: Forever I'm Yours (for QoS)
- Shirley Bassey: No Good about Goodbye (also for QoS, originally intended for Amy Winehouse, co-written by David Arnold, cues from this song are still in the movie's score)
- Blondie: For your Eyes only
Intriguing ones:
- Straw: The World is not enough (lyrics are full of references)
Nice ones, but not really Bond
- Johnny Cash: Thunderball (Rawhide meets Bond)
- Alice Cooper: The Man with the Golden Gun
- Swan Lee: Tomorrow never dies