Pierce Brosnan was my favorite Bond. I liked Sean Connery as well.
I hated Roger Moore though. When he started, he was OK. But later he just got too damn old for the role.
I thought Casino Royale was awesome, and recently bought it on blu-ray.
Anyway, I just watched Quantum on blu-ray, and it was very disappointing.
Martin Campbell has made two of the best Bond films to date; Golden Eye and of course Casino Royale. He is also currently doing the Green Lantern movie, which could be good. Too bad he didn't come back for this one.
Marc Forster, who helmed Quantum, was a bad choice for a Bond film. He is the guy who directed among other films, Monster's Ball (that interracial porn which won an oscar), Kite Runner, and Finding Neverland. I don't think he was the right guy.