For me, Moore was always my favourite Bond because I grew up more with his movies than with Connery's. I think that, along with From Russia With Love, The Spy Who Loved Me could be the quintessential Bond movie.
Having said that there's no doubt that he doesn't have a tremendous range as an actor, certainly much less than Connery and Daniel Craig, but he does what he does very well - Suave and charming, and he had terrific comic timing. And he could be pretty cruel when he needed to be - Check out For Your Eyes Only when he boots the guy off the cliff.
I'm also convinced that Daniel Craig is going to absolutely kick ARSE in the new film - He'll be hailed by some people as the best Bond ever, mark my worRAB.