Roger Moore was easily my favourite Bond and Live and Let Die and The Spy who loved me are my two favourite Bond films. I've heard he was a nice bloke too, by all accounts.
One thing I've never got is why women were supposed to find Sean Connery attractive, I know it's difficult to comment, being a bloke, but to me he looked a bit like your Dad, or someone who might have played for a team like Oldham Athletic or Port Vale in about the late 50s.
It's a very subjective thing. Over the years I've debated this with a good many people and there is always a mixture of responses. The majority I have to say prefer Roger Moore with Connery next. On thing I can't say is that I like all of them because I don't. I just can not take to Daniel Craig in the role at all and certainly not a fan of all the CGI crap in them now.
One thing I would love to have seen would be Lewis Collins in the role. He ticked all the boxes but wasn't liked by Broccoli and he was deemed too aggressive in his interview so alas it never happened.