One from each, excluding Lazenby (who happened to make my favorite) and non-canon (Never Say Never Again):

Connery - Diamonds Are Forever
Moore - A View To A Kill
Dalton - License To Kill
Dalton - Die Another Day
Craig - (I’m about to commit sacrilege here!) Skyfall

Overall top worst:
Diamonds Are Forever - the tone change between On Her Majesty’s Secret Service and this is jarring to the extreme, the fake-hip dialogue stinks to high heaven (“forget it, Charlie! You had your chance and you blew it!”), the mafia types were obsolete, quaint and flat cinematic caricatures, when The Godfather came out just a few months later.
Bonus negative points for an unfit and disinterested Connery, seemingly in constant self-amused form at how little effort he can get away with onscreen for a then record million-and-change dollar salary.

BUT…! There is another one, so much worse, but mercufully non-canon: 1967’s spoof Casino Royale, with David Niven, Peter Sellers and Woody Allen. Oh my GOD is that thing unwatchably awful!