James Bond

Sean Connery is the only James Bond who ever made any sense whatsoever. Runner up: Pierce Brosnan.

The character concept is he is a one-woman man whose one true love -- his wife -- died and he's incapable of falling in love again because he still loves her and always will, so he's a hard drinking, not-quite-suicidal man who has accepted a job that could get him killed in service to his country and both because he is heartbroken and his job makes it unsafe for anyone to be close to him, he takes his comfort where he can, in the arms of short-term trysts.

There's actually a real life person similar to that: Richard Feynman. 

Sixteen months after his wife died, he wrote a letter about how much he STILL loved her. He became something of a ladies man, unable to love again, and women said things along the lines of "Yeah, he made a pass at me. He's also the only man who took me seriously at work."

The James Bond character made sense in the 1950s when casual sex was still frowned upon. Then along came the 1960s and the entire premise of "He's so suave and debonair and in some way special, so ladies throw themselves at him even though most chicks are saving it for marriage." just stopped making any sense whatsoever.

The Roger Moore era was shockingly rapey and I have absolutely no idea why. Maybe they were trying to somehow navigate the disconnect between the premise of the character and the new reality of "liberated women" and it went bad places.

Pierce Brosnan was, in actual fact, a man whose beloved wife had died and who wasn't readily moving on and he brought something to the character that helped make it palatable in spite of how out of step with reality the movies had become.

There's something called Comic Book Time where for storyline purposes, some things move on and some don't.

I haven't seen recent movies in this franchise -- in part because I have no life and in part because "Ugh. Why bother?" -- but last I watched any, the franchise has Bond stuck in the 1950s only not and it's not really working, frankly.

Could it be reworked so it makes sense? I don't know.

Some men really do have a way with women and see action from women who aren't the casual sex type. 

But the premise that Bond sees action and that alone is weird would need to be thought through carefully because that's just not reality anymore.

Unless you want to make him Saudi Arabian or Iranian or something.