For me its still Connery.....but Craig is a close #2.
One reason being IMO Craig had the benefit of special effects Connery never had.
OBTW Roger Moore (RIP) is still a dead last....those were lean years for Bond,James Bond.
Just my 2 cent
But I always had a problem imagining him being a spy when he portrayed Bond as someone who goes out of his way to make sure everybody notices him. That's not spy-ish. A spy blends in either unnoticeably (like Dalton, Craig, and sometimes Moore) or as a harmless buffoon no one would see as a threat (like Lazenby and sometimes Moore did). When I watch those actors play Bond there's part of me that goes "yeah, I could see a real spy acting like that". But being tall, flamboyantly handsome and noticed by everyone immediately always makes it hard for me to take Brosnan or Connery as spies trying to do things under the radar.
I always figured everyone has two favorite Bonds: Their first and Sean Connery.
The Golden Age of Bond Movies: You Only Live Twice to The Spy Who Loved Me. (Many will disagree, I know.)
And Barbara Bach remains the Best Bond Girl ever. (I ignore that her character was a Commie).
No way! Yeah, there was some bad screenplay in those, but Dalton was the worst Bond, IMO. Never convinced me that he was playing James Bond.