I mostly agree with ChainsawAsh's list, though I would add For Your Eyes Only as it is rather Fleming-esque as well as being the only one of Roger Moore's films that can be watched without cringing. I also have a lot of fondness for GoldenEye, being the first one I ever saw and definitely Brosnan's finest outing. Doesn't hurt that the game is kickass, too. ;)
Interestingly, I have heard that the script for GoldenEye was written with Dalton in mind, and that the reason he is being evaluated in the beginning is to see whether he's really worthy of being reinstated as a 00 agent after leaving in Licence to Kill, which puts a different sort of perspective on the film.
To try to say something not off topic (lol), I would absolutely hate to see a James Bond prequel. Although in a way the Casino Royale movie nearly qualifies, since it starts with Bond getting his licence to kill and he is at an earlier stage in his life and career than we're accustomed to seeing him, but since it is in its own continuity it doesn't really count as such.