I started with Moore but now look in retrospective, he´s the worst, that humor you pointed at made the character a buffoon. Jams Bond is a though, depressive, almost alcoholic guy, violent, difficult to control. Moore make it a cute Superman type of hero that never lost his hairdo and rely on cheap humor to get the girl or retort the bad guy.
Of course is my opinion, you can defend yours and it's perfectly valid, that is what argument is all about.
Au contraire, it has a definitive plot and the character has change. He's a MI6 operative not superman, there's no need for another Blofeld (although I think Mr. White will take over it). If you look closely at the plot is about politicians manipulations, control of world resources, revenge and I think that's great. I was getting tired of the impossible Bond stunts, the always in the nick of time Q gadgets save the day, etc.
After Casino Royale to me is the best since "The Living Daylights".