Sean Connery will always be the standard for Bond, no matter what. That being said, for me Daniel Craig is my favorite (and made me a "true" Bond fan in the first place). Skyfall is actually my favorite Bond film of all time.
After those two, Roger Moore would be my third. Totally different...