I think Bond is who he was when you first watched. So Dalton will always seem like Bond to me. Not particular charismatic, not particularly athletic, not particularly good with the ladies. But the universe around him just gets bent to his will so effortlessly. No sweat. If I were designing a prototype secret agent, I'd want a guy like that. You wouldn't remember seeing him at a party. You wouldn't remember bumping into him. When scanning a room, you wouldn't consider him a threat.

Unfortunately, for all those reasons, people didn't like watching movies he was in. Ah well, a more realistic secret agent is too boring for movies I guess. And yeah, kind of goes against everything Bond is supposed to be.

Edit:

I kind of love the fact that he's in third place after my vote. Pipe dot, you get me.