Sean was/is the man! But, to be honest, give Daniel a few more, and he could be right up there with the best of them. Albeit the scripts had better come better and better...
Craig and Connery are tied for me. Connery, because he is the original and Craig because he is aloud to really act it in the role. I liked the last 2 movies a lot and actually have them both on my Curve.
Gadgets, I would probably pick the Omega watches that Brosnan wore in his movies.
Girls, I liked Eva Green (Vesper Lynd in Casino Royale) and Gemma Arterton (Strawberry Fields in Quantum and no I am not making that up it really was the characters name).
I am a huge Bond fan. I have all the movies on DVD and almost all of the books in hard back. I proposed to my wife after we had just finished watching The World Is Not Enough. We had already discussed that she was a bond fan when we were dating. I am wearing the new Omega Planet Ocean that Craig wears in Casion Royale and Quantum of Solace right now and I did buy it because it is a "bond watch". I used to own a Walther PPK, but really didn't like the gun so I sold it.