It has to be Connery. There wouldn't be a franchise if he hadn't embodied the role.
Dalton, despite the flaws with both films, was years ahead of his time by essentially taking the character in a similar direction to the one Craig would later be praised for.
Brosnan never really hit the heights of Goldeneye in his subsequent films, unlike Craig who at least departs from the role with a sizable body of work behind him, and no real stinker of a film. (QoS isn't all that bad, and could have been much better had the writers not gone on strike during production)
Moore and his perennially raised eyebrow can be best ignored.
Older women are best, they always think they may be doing it for the last time.