I agree that I'd put Goldeneye as the best and Quantum as the worst, but other than that:
Personal favorites:
Goldeneye: Utterly Brilliant. Reinvented a dying franchise. Love it.
The Spy Who Loved Me: Fun, fun, fun - everything a Bond film should be. Plus Barbara Bach.
You Only Live Twice: A bit racist viewed through today's filter, but Donald Pleasance nails it.
Casino Royale
Ones I like a lot that are not highly regarded by Bond fans:
Oh Her Majesty's Secret Service: The last of the glamour 60s Bonds, and a more mature and vulnerable approach to the character
For Your Eyes Only: A proper old fashioned spy caper, criminally underrated.
Never Say Never Again: I always enjoy this one.
The Living Daylights: The franchise was looking a bit tired by this point, and was struggling to compete with big budget movie blockbusters, but what's not to like about Timothy Dalton and Maryam D'Abo ski-ing down a mountain on a cello?
Licence to Kill: Its basically an episode of Miami Vice, but still fun
Ones I enjoy but don't get the reverence for from the fanbase:
From Russia With Love: It's just alright
Thunderball: ditto
Diamonds are Forever: Plenty O'Toole - "named after your father, no doubt"
The Man With The Golden Gun: Christopher Lee is seriously underused in this.
A View To A Kill: Fun, but Roger Moore is old enough to be her great-grandfather - icky
Tomorrow Never Dies
Skyfall
Least Favorites:
Dr. No
Goldfinger: Bond does nothing, he's totally passive throughout, the plot would have unravelled in exactly the same way if he hadn't been there.
Live And Let Die
The World Is Not Enough: One of the least believable things in any Bond movie - Denise Richards as a nuclear scientist.
Awful:
Spectre
Octopussy: Bond defuses a bomb dressed as a clown and there are plenty of hijinks with a man in a gorilla suit in a sub-plot lifted straight out of an old Marx Brothers film.
Moonraker: The Space Cavalry arrive to save the day with space laser guns. Let me say that again just in case you failed to appreciate how daft it is - The Space Cavalry arrive to save the day with space laser guns.
Die Another Day: The invisible car. Need I say more?
I walked out of the cinema and never saw the whole film it was that bad:
Quantum of Solace