I agree with most that Connery was the best. They all had some moments. I actually thought Lazenby did a good job. Some of the cornball crap that was in the Moore era was just pathetic. I think my favorite movies are From Russia with Love and Goldfinger. The really smart thing about the Bond movies is that they don't stray from the formula; girls, guns, gadgets.
They are all predictable, yet still always entertaining. Some more than others.