Goldeneye was good and I like the stuff with Michelle Yoeh in Tomorrow Never Dies.

Die Another Day started out well but fell apart when Pro's favorite Catwoman showed up.

Interestingly enough, the guy who directed Goldeneye, Martin Campbell, was also the director of Casino Royale. That would seem to confirm that the problem was the producers who, one can see, clearly started edging Brosnan back to the Roger Moore silliness with each subsequent film.