Agreed, Connery's the 'real' Bond, even if Ian Fleming didn't like his casting at the time. Moore was a pathetic smarmy joke without a punchline, and the Bond franchise barely survived his miscasting (and the whole campy Adam West self-parody feel the Bond films took on).
Dalton was a great Bond, and he ought to get credit for saving the Franchise and bringing it back from the brink. He was the first real 'action' Bond after Connery. He was gritty and believable (it's a movie, dammit). The cast and scripting around him seemed uneven and still uncertain where the Broccolis wanted to take Bond after the ladyboy years with Moore. Dalton is still my favorite Bond after Connery.
Then they dumped Dalton for Brosnan, who they wanted all along and had already signed but dropped out when Remington Steele was renewed at the last minute. By then Dalton had brought new life back to Bond as an action series, rather than camp farce.
Brosnan was a throwback, a younger Roger Moore all over again, another ex-male-model implausibly put into what was now once again an action series. The casting of Judi Dench helped carry the films but Brosnan was always an empty suit in the middle of the story.. I think most guys could imagine themselves taking Brosnan down in a parking lot if they really had to, and that's not good for Bond.
I'm not a fan of Craig, but he has the Clint Eastwood less-is-more 'stone face' shtick down. He's the most 'pumped up' Bond, which is not Ian Fleming but then the movie scenarios no longer have much connection with Fleming's Bond.
His mother-son undertones with Dench progressed from a nice touch to jumping the shark, and Skyfall was a nonsensical mess of a script.
Bond movies are just another Fast n Furious video game now, a string of fast CGI action sequences with no plot to tie them together. Craig's fight scenes are mostly humanly impossible, all CGI effects.
Hmm. We started out talking about Bond's knife...