I always looked on Roger Moore as a waggish joke and could n't take him seriously. He probably got the role on the strength of 'The Saint' series, a role that suited him very well.
For some reason Sean Connery has been elevated to the ultimate Bond. I suspect he finds this amusing and ironic, I know he wanted very much to escape the Bond stereotype. I must say that, for me at least, Daniel Craig is head and shoulders above all the competition as the definitive Bond, and the only one to be taken seriously.