We've done this one a few times.
The best Bond film is definitely Casino Royal. Not just a great Bond movie, just a great movie.
Each Bond era has a different style which reflects the times. They are difficult to compare.
The Craig movies are the best films and Craig's is the most developed character. His efforts are generally serious, but if you want daft hammy enjoyment then look no further than Roger Moore. His best effort was Live and Let Die. Great when you were 9 years old at the cinema. His worst was probably For Your Eyes Only.
Connery was a good Bond, but the films are very dated now. I liked Dr No and Goldfinger but despite having some memorable elements, the others are a bit dull. Thunderball is very forgettable.
Timothy Dalton was underrated. His first effort was a bit feeble, but Licence To Kill is one of the best.
Lazenby was OK, but the film was silly. Telly Savalas presumably only got his part because he was bald.
It was the first Bond I ever saw, so I have a slight soft spot for it.
Pierce Brosnan. Er no. I like him in other stuff, but his films had no sparkle. I have rarely rewatched them.
So for me, Craig is the best Bond and has the best film, although I loved Roger Moore. He was my childhood Bond and will always be a move hero for me.