Craig is a good bond, he doesn't have the facial looks that would attract the ladies imo, best physique of them all though. He looks solid enough to take a beating and put himself through some punishment.
I found Connerys films the most boring, lack of action etc, Moores got the big budgets and were considered event films by then, he had the smoothness, sarcastic wit and one liners.
Lazenby was just a useless Bond but the one film he did was decent, Dalton's 2 films were really good but I just didn't like him as Bond, too uptight, always seemed like he said his lines through gritted teeth.
Brosnan was like a mash up of Connery and Moore, amazing that by the end of his run the gadgets had become ridiculous, the series was like a parody. I watched Die another day and thought what the hell do they do now, there was that ridiculous virtual reality training scene and invisible car like batman and robin fantasy level.
I thought the series needed to be stripped back and luckily someone in charge had the balls to do it, I've heard the new one has gadgets again, just hope they don't start the trend of outdoing them each time like before.