Connery was not very tongue in cheek at all. Moore and Lazenby, on the other hand, were comic buffoons.
I have no problems with Craig. I wouldn't put him up with Connery - who was so good Ian Fleming changed the character to be more like him - but he captures the meanness and the ruthlessness of the character really well.
Also, crashing VW Beetles in a Bond film. At last.