1. Connery. No contest.
3. Brosnan and Craig (tied).
4. Lazenby. Not a particularly good actor (although he had his moments), but as he was in what is by far the best Bond movie he gets away with it.
Moore is in an abyss somewhere. Unwatchably, awfully, atrociously bad.