I'll admit that I really enjoyed Die Another Day, as silly as the storyline is sometimes (it is a Bond film after all), the car chase was great, the intro sequence is good (actually, I used it as my test to make sure that the 5.1 Surround Sound is working when we bought a new home theatre system) and the action was fast paced.
One of the coolest cars in the series has to be Wet Nellie, the Lotus Esprit submarine from The Spy Who Loved Me, I think.
Pierce Brosnan is my favourite Bond, he just fits the part so well. Sean Connery was great to watch and the original Bond. Roger Moore did a good job in my opinion, but I never really liked him as much as some of the other ones.
I haven't seen Casino Royale yet, looking forwards to it.