Your answer to this probably depends on your age group. I bet that most of old old timers prefer Connery.
I feel like everyone since him are just imposters.
I'm 20 and think Sean Connery in Goldfinger is the best IMO. Age doesn't necessarily mean anything on something's. I'm not a fan of any of the newer ones with Daniel Craig. Not that I don't like him or that they aren't well produced films, they're just too "modern" and not as witty as the older ones
I had the highest of hopes for pierce brosnan after watching goldeneye when it came out, was disappointed in every movie he made after that.
After going round and found with this question through the years Connery still tops my list as no 1.