I am actually quite impressed how they have always managed to find good actors for the role. All of the six are pretty good at what they do and have at least one film where they absolutely nail the role. But there are also arguments against all of them. Connery probably has the best run in terms of film quality, I really like his first four, Dr. No-Thunderball, and his charisma in those is unmatched. However, he probably also gave the worst performances in the entire series in You Only Live Twice and Diamonds are Forever, which are also quite weak movies.
Lazenby stars in my favorite Bond film, and gives a great performance, they made the mistake of dubbing him in a significant portion of the film which lowers the overall impression of his performance, but in the rest he was awesome, especially at fights and the more emotional aspects. I don't think Connery did emotions as well as Lazenby.
Moore nailed the humor and charm of Bond, unfortunately he probably had the weakest movies. The Spy who Loved me and For Your Eyes Only are solid, and some of the others are kind of guilty pleasures for me, Octopussy and A View to a Kill flat out suck though.
Dalton is pretty good as well, bringing back the more grounded aspect to the role, and delivering more emotional performances. Licence to Kill does feel a bit too much like a product of the time though. I think the glamour is also part of Bond, and Dalton is lacking in that aspect.
Brosnan is the perfect Bond imo, and my personal favorite, as he has a bit of everything that defines the character. He has charm, charisma, humor, feelings, he is handsome and a gentleman, but can also be dangerous. Some say GoldenEye is his only good one, and I agree it is his only stone cold classic, but I think The World is Not Enough is seriously underrated and much better than Tomorrow Never Dies, which has a very boring second half (still it is a guilty pleasure of mine). Die Another Day was atrocious though.
Craig blew me away with Casino Royale, and I am one of the few who actually like Quantum of Solace. Skyfall is probably his best one and the one I rewatch the most. Unfortunalely the last two have been so horrible, to the point that he dropped from my favorite Bond to third. Those two are just drained of the life and magic of the series, no fun, no humor, no glamour, just dark, dull, depressing, drawn-out movies filled with plot-holes and poorly written characters. The fact that Craig himself influenced some of these terrible decisions doesn't help. What is up with giving him an "arc" across five films? I hope they skip that terrible decision for the future films, one film - one story is the winning formula.
So my ranking is probably:
1. Brosnan
2. Connery
3. Craig
4. Lazenby
5. Dalton
6. Moore