All the Daniel Craig films, all the Roger Moore films (with the one exception of FYEO), all the Brosnan films and TLD are as tonally weird as Diamonds Are Forever.

I've never understood the negative buzz for QOS, the film is just as good/bad/silly as Casino Royale and Skyfall is if anything more silly and less interesting (especially in the final act).

Bond films are silly films by definition just look at Dr No.

The reason LTK didn't feel like a Bond film was because it was being too close to a Bond book (ironically considering the source material wasn't Fleming).