
As a Bond purist, I think all the movies that followed Ian Fleming's books were good movies. That includes most of the Sean Connery movies, definitely On Her Majesty's Secret Service (for which George Lazenby got shafted... it was one of the best movies made). The only Roger Moore movie I liked was Live and Let Die. All the rest of the movies, including the Brosnan and Dalton ones were schlock, in my opinion. I am anxious to see how Daniel Craig works out.
With that in mind, there's no question that all of the title sequences were good, no matter which movie you're talking about. And here's an awesome link to all the James Bond title sequences:
Martin Klasch: Video: The James Bond title sequences