He's definitely had the best written Bond IMO. The "smooth" Bond is kind of an inherent contradiction for someone who's a field operative...I always thought the gadget and finesse-driven Bonds (ala Brosnan) were corny in terms of believability working in the field.
That said, I think if you swap in Brosnan for Craig w/ Brosnan matching Craig's physicality, you do get someone who could rival Connery.
Craig deserves credit for bringing the physicality and being a good enough actor to bring depth to Bond, but I think Brosnan could have too. Brosnan's movies were trash though. Craig has a certified Bond classic (Casino Royale) and Skyfall is also good to me whereas I don't think any of Brosnan's movies were actually good.