As a teenager, I was a big fan of the Bond franchise but preferred the books to the films..
While Connery is the classic Bond, I don't think the films have dated very well, with what looked "spectacular" at the time now looking decidedly cheesy and the plots being pretty unbelievable..
Moore and his films were a joke and nothing like the original books..
Dalton was too much of a "new man" type and never came across as menacing..
So my two favourites are Brosnan, who I think as a modernised version of Connery, and Craig, who is probably the best of the lot, but plays a very different character to the others.
That said, I am not sure how long Craig can go on for as he off screen he is looking very old and very tired..