Roger Moore was fun, yes, but in some movies it was just way too campy and way too comedic for me to take them seriously (I confess that that was probably the point though).
I used to hate Lazenby, but not too long ago I actually sat through On Her Majesty's Secret Service and I thought it was a brilliant film. In many ways, it echoes a lot of the Daniel Craig Bond, in that he actually has a meaningful relationship with a Bond girl (as opposed to just banging Yet Another Disposable Piece of Eye Candy).
All in all though, below Connery, my favorite Bond was Dalton, and my favorite movie was The Living Daylights. Dalton just seemed to have the right mix of professionalism and humor to make it all work.
The worst Bond film out of all of them, in my opinion, was Moonraker. I just about lost it when the USA shuttles appeared at the closing scene and all of the little Space Marines started popping out shooting pew-pew lasers.