I’ve always preferred the films where they get Bond closest to the ruthless killer of Fleming’s books:
Dr No, with the classic “you’ve had your six” line, Live and Let Die was the closest Rog ever got to that, and the new Casino Royale was excellent or the same reasons.
Conversely, the more hammy they made the dialogue, the worse the films became – Diamonds are Forever was pretty bad, and the later Roger Moore films were risible.
Quantum of Solace indicated a worrying trend back towards blowing up supervillain lairs which the Bourne films, and Casino Royale have shown to be pretty unnecessary to making a decent popcorn/spy/action film.