Not only that, but there have been several times when he's virtually raped girls. By that I mean them struggling and resisting, before finally 'caving in' to his 'manly charms'. Not counting the time where he blackmails a girl into sex.
Besides which, if smarmy cheesy scotsmen were attractive then my friends here would be getting a lot more action than they do.
Have you seen the teaser for Casino Royale, seemingly aka James Bond Begins.