Connery was IMO the best mix between sex, violence, wit and british twinkle-eyed humour, closely followed by Brosnan.
Dalton was terrible in "License to kill" 'cause he tried to make Bond a "deep" character, and took it to seriously. "Daylights" was quite enjoyable though.
Lazemby was the...