Loved Connery in the role. None I feel have come close to being as good. I'll give chops to Craig for making Bond rough and tough again.
I have always thought that Clive Owen should have been the next Bond, before Craig was chosen. Gerard Butler would be my second choice. I would also add Russell Crowe to the list.