That's a really tough question. My favorite would have to be From Russia with Love... Connery was really into and having fun with the role; Robert Shaw... c'mon, how cool was he !?!; The Russian girl was one of the most beautiful of the series; The story was good old-fashioned Cold War Spy vs Spy (and very faithful to the Fleming novel).
My worst has to be one of Moore's... probably Octopopsicle, maybe View to a Kill.
I actually liked Dalton very much... after Moore's double-taking-flinching-while-shooting-smarmy-prissiness, he seemed to be a step upward.
I had read all of the novels at a pretty young age, before seeing most of the movies (Dad was into Bond). I think Brosnan actually comes closest to the literary Bond.
Want a good story? Find and read the original short story of A View to a Kill or The Living Daylights.