No Bob Holness, Barry Nelson or David Niven? :wink:
Connery, of course, though Brosnan is a close second. CN is correct, Goldeneye was the only decent Brosnan film.
I've never read the books, but I'm told Bond is Scottish in them, and a bit of a thug, so Connery was perfect for the job IMO.