James Bond was the hero England needed at the time in response to the general dreariness and deprivation most English people were feeling in the post-war years. James Bond is this "omnicompetent" character, he always knows what to do, what to say, how to act in any given situation. He also experiences exotic locales with fine food and drinks. In some ways he represents a return to the "old days" of the British Empire when the UK and England was more relevant and also he represents (especially) masculine wish-fulfilment.

But yes, I can see how to modern audiences it's not so exciting and seems stale. But at the time, it was "hot" because Fleming created so many of the tropes that now we see as tired or dated.