My ranking of Brosnan films (best to worst):
* Tomorrow Never Dies - Classic Bond villain. Best Bond girl ever. Great musical score. Yes, kind of a rip-off of You Only Live Twice and Spy Who Loved Me, but in a way that's also what I like most about it. It's the most "Bond" of Brosnan's films.
* Goldeneye - Fantastic pre-title sequence. Good choices for Bond girls. Suffers from weak villains and horrible music score.
* The World is Not Enough - This one really pisses me off. It really should be number one. Best script. Best score. Best pre-title sequence. Best title song. Why is it third? Two words: Denise Richards. Yes, there have been Bond girls before who couldn't act their way out of a paper bag, but they were never given the job of playing a nuclear scientist, having to support the second half of the film, and having to appear to be Bond's equal. Every scene she is in she manages to
totally destroy. I;ve never seen a performance doom a film quite like that before.
* Die Another Day - Just awful. Brosnan's "Moonraker". Halle Berry was horribly miscast. Crappy "let's make this look Hong Kong-style" directing. Implausable even for a Bond film. And Madonna. Let me just say that again. [rant]MADONNA![/rant]
As for who would be the best new Bond? Adrian Paul. There can be only one!

-Lyle J.P.