I thought Connery was the perfect Bond. He had the looks, the charisma, physical strength etc., and was very believable.
I would have liked to have seen Lazenby play Bond again. I'm not sure whether it his acting or the film OHMSS that made him stand out (film had everything - 2 Bond themes, Telly Savalas, Diana Rigg, Aston Martin DB5, Ski scenes... but then it did have him in a kilt lol)
I enjoyed Roger Moore for his comedy value and Brosnan was great in Goldeneye. I wish Dalton had better stories because I think he could have given something a bit better.