My favourites are Dalton and Craig.
Connery was alright, but I found his Bond character best in Dr. No, although From Russia With Love is my favourite Connery era Bond film, and On Her Majesty's Secret Service was one of my favourites despite having not so great of a Bond. Similarly, I also liked Moore in Live and Let Die, which I also liked a lot as a film, but not so much in later films. I am probably one of the rare people who enjoyed A View to a Kill, it is normally near the bottom of people's lists.
My favourite classic Bond era films are: From Russia with Love, On Her Majesty's Secret Service, Live and Let Die, A View to a Kill.
My favourite modern era Bonds are Living Daylights, License to Kill, Goldeneye, Tomorrow Never Dies, Casino Royale, and Skyfall.
Overall, I prefer the darker modern films over the sillier classic films. Though I find them difficult to compare, there is a stark difference between the films from Dalton onward to the films from Roger Moore and earlier; they're almost like two different genres. GE007 has some horrendous dialogue, but I still find it to be a great film with a great villain.
Unfortunately, Bond has not been as consistently good as Mission Impossible: the worst MI film is MI2 which IMO is still a better film than the 4 other Bond films from the modern era. The remaining MI films like more as a group than my favourite modern Bond films.
I describe myself as a little dose of toxic masculinity.