I haven’t seen all of the older ones so can’t fully comment but from what I have seen I agree with you here. Brosnan was sold a pup after GoldenEye. All of them were pretty shocking culminating with whatever Die Another Day was.Just done all the bonds over a two week period courtesy of Amazon. (I hadn't seen 'No Time To Die' so took the opportunity to hammer them all)
The Daniel Craig films are by far the best ones when taken as a group with a connected storyline.
The Sean Connery films are generally pretty crap (Yep, even Goldfinger) but he definitely played it cool.
George Lazenby? Also pretty good as Bond and I wouldn't have minded another outing from him but it wasn't to be.
The Roger Moore ones are Austin Powers with a bit more shooting.
The first Timothy Dalton one was OK, the 2nd was garbage.
Pierce Brosnan played the role with more Connery than Moore, and pulled it off quite well, they just didn't give him the best stories. (but clearly the best ladies, quite a prolific line up)
That brings us back to the Craig films. They definitely took note of the Jason Bourne films and dropped the daft jokes. Those last 5 films are probably the only set I'd bother watching again.
Oh, has there ever been a more useless 'baddie' in cinema than Jaws? He's literally just a lumbering oaf. Bloody useless.
Casino Royale is my favourite Bond film by far. Quantum of Solace was pretty rubbish but I’ve enjoyed the other Craig outings.
Will be interesting to see where they go next. My guess is they go with someone young and if I had to put money on it I’d say it will be Rege-Jean Page.