I liked Roger Moore's more comic movies. They've pretty much abandoned all the tongue in cheek stuff with the Daniel Craig ones.
Probably due to Die Another Day being so silly.
But even Connery's movies had slapstick and one liners.
I'm a bit bored of " grounded, realistic, gritty " movies at the moment. I blame The Dark Knight.