Time to chime in.
For me the question boils down to Connery and Moore. As much as I've enjoyed Daniel Craig, I'm not sure if I've actually be more impressed at how good he is rather than how relieved I am that he wasn't as bad as most had once thought. We'll need to see more of him to know. The fact that so many of you have him as second best only goes to show that with a few more films he might be worthy of discussion.
Brosnan was fine. But he suffered from taking part in 4 Bonds that were basically glossy Macgyver's.
But here's the argument for me. I've never read more than 2 of the books so Bruce's argument about how true he is to the written version is lost on me (for the record, if this was an argument about how true the character was to the book, Craig would be streets ahead of Brosnan and the poll would be faulty

. ) I'm not sure how many of you are purists in that manner.
On the face of the movies though, Connery portrayed Bond as a small fish in a big ocean. Sure, he enjoyed the women, he enjoyed the gambling and the liquor and the lifestyle of a spy. But a true spy is never impressed by his surroundings. Even the baddies seemed to latch on to this - he's constantly being looked down upon by snobby villians. Connery suffered from being himself. Moore went into the role being himself too, but he was miles apart from Connery. Moore was able to take the role and wear it proudly - he was much less a 'visitor' to the lifestyle. Connery took on the role like a teen walking into a trendy nightclub for the first time. A problem I have with Connery is also how he basically went around the Bond girls like he was desperate for some action - almost like he'd never gotten much before. Moore on the other hand used sex as a tool. He uses it to extract promises, interrogate - much more spy like.
A last point - Connery never really delivered the one final badass blow to any of the Bond baddies. They either died because of their own incompetence (GOLDFINGER) or he had a Bond girl do it for him.
I note that most of my arguments are based on storyline, and script. Maybe it had to do with the era of cinema, but in the end it affected on the way I viewed the character and to be frank, I don't see how I could do it from any other point of departure.