I just saw Goldeneye again this past weekend and still don't understand all of the love this film gets. It was average at best, and got off to a horrible start during the pre-title sequence when Bond drove off the mountaintop and "flew" into the plane's cabin. Awful opening. The best thing in it was Famke Janssen. The plot was ordinary, the music was sub-par, Brosnan wasn't quite comfortable with the role yet, and both Sean Bean and Izabella Scorupco were simply bland. The idea of 006 turning evil was a good one, but Bean didn't exude much charisma or menace as a main villain. He should have been somebody's henchman/right-hand man. And there really wasn't a memorable action scene either. True Lies came out a year before and those action scenes kicked ass (-- while still being flawed).
Overall, Goldeneye was okay, but not top 5. It's really hard to compare the films because despite following a familiar formula, the approach taken with them over the past 40 years has radically changed with the times. It's hard to believe all of them belong to the same franchise. Moonraker and For Your Eyes Only were released back-to-back, but couldn't be more different in substance and tone from each other.
My personal preferences, in no order, are:
For Your Eyes Only -- If only John Barry did the score -- Bill Conti's music was horrible. This was a much more realistic and down-to-earth Bond compared to the previous Moonraker installment.
The Spy Who Loved Me -- Over-the-top, but fun. Marvin Hamlish's score was horrible as well. I like maniacal villains who intend to take over the world. Moonraker was simply a retread of this.
Live and Let Die -- See Poxy's comments above. A slightly different feel for a Bond film.
License to Kill -- Only because I wanted to include Dalton, and it deviated from the formula more so than many of the other films.
Goldfinger -- series started to find its groove.
Thunderball -- SPECTRE, jet-packs, underwater battles, Largo, etc.
I found it hard to get past Lazenby in On Her Majesty's Secret Service (-- great theme music, though).
Note that I haven't seen Die Another Day yet. Don't know what to expect since there have been some quite divergent opinions on it.
And bring back SPECTRE.