I prefer Daniel Craig as I think he is the only actor that had portrayed Bonds cold & clinical demeanour, a bit closer in character to Flemmings Bond. Though I feel the Bond villians in his movies have been below par and no memorable henchmen or sidekick.
As for the rest, Connery was excellent in the older films, Moore was too hammy and corny, though as I boy I loved the 70's films, probably because of the gadgets, girls and cars, Brosnan was too preened and pouty and Dalton has little or no screen presence. I've only watched the Lazenby film once and can recall little of it, does his wife or girlfriend die at the end? I've never watched the film with Niven as Bond.