One article I read put it this way- The appeal of James Bond is that he has enough skill to handle himself in any situation. Competence is his superpower

It doesn’t matter if he is playing high stakes poker or being in a gunfight. Skiiing or ordering a drink. Using high tech gadgets or driving a classic sports car. Going to a formal party or swimming at night in SCUBA gear to get there. He can do it all and look cool doing it

The movies still aren’t my thing but from that lens I can understand the character.