Right, here goes. Actually my favourite Bond was Timothy Dalton and there's no Welsh bias involved here. I read Bond from an early age and, to my mind, Dalton's interpretation was more accurate in terms of what I read in the books - of perhaps how Fleming envisaged his film persona.
Certainly, I have read many critiques from Bond afficionados who also agree that Dalton's Bond was the most reflective of all the actors chosen to portray him. Surprisingly, or perhaps not, Daniel Craig ranks highly in this respect as well. Fleming's Bond, although suave, sophisticated and certainly a man of the world, was, in effect, a cold-eyed killer who possessed far less humour than shown by the other actors. He was a spy, a special agent, motivated by the realities of his profession in grim austere times after the war, rather than a playboy type fitting his job in between seducing glamorous females.
Of course, there's nothing wrong with Connery's Bond, nor for that matter with those of Moore and Brosnan. The films were highly entertaining, enjoyable and the actors were very good in them. Even Lazenby put in a pretty decent performance given his limited acting experience, even if he was hugely supported by the talented Diane Rigg who helped him immensely in carrying out the role.
I suppose it boils down to what floats your boat. Connery, Moore and Brosnan played it more for laughs than did Dalton then and Craig now. Personally, I prefer my Bond more downbeat because that's how Fleming wrote him but I understand that others will have their own opinions, preferring the gadgets, the gimmicks and the one-liners. Nothing wrong with that because I enjoyed them too.