The closest i was to this franchise was GoldenEye for N64 back in the good old days. i never watched any of the movies until recently that i saw almost all the movies in a streaming service. Here is my ranking:

1. The Man with the Golden Gun
2. Thunderball
3. For Your Eyes Only
4. From Russia with Love
5. Octopussy
6. Diamonds Are Forever
7. Live and Let Die
8. Dr. No
9. A View to a Kill
10. The Spy Who Loved Me
11. Moonraker
12. You Only Live Twice
13. Goldfinger
14. On Her Majesty's Secret Service

sadly the movies are no more for the time being in prime so here ends the ranking for now.

Bonus rank - Bond Girls

1. Domino vitale
2. Plenty o'toole (special mention)
3. Fiona Volpe (special mention)
4. Tatiana romanova
5. Solitaire
6. Melina Havelock
7. Pussy Galore
8. Tiffany case
9. Honey Rider
10. Mary Goodnight
11. Stacey Sutton
12. Anya Amasova
13. Holly Goodhead
14. Kristina Wayborn
15. Tracy
16. Aki