Seriously, after the frivolous Roger Moore James Bond movies, the series pretty well burned out. It was somewhat brought back by Moore’s successors, but finally got a shot in the arm by Daniel Craig, who played Bond as a serious character again.
Fleming’s Bond was intended to be a generic man, with an average face, someone who could get lost in a crowd. He did not have lots of money, wasn’t a brilliant expert on every subject, and as often as not lost in fights. He was an assassin, not a detective.
The first Casino Royale movie, an anarchistic surreal comedy, actually pegged James Bond correctly, that his name and 007 number could be applied to anyone, or everyone, like a spy equivalent of military rank. This was done with the idea that the *reputation* of the original James Bond 007 was such that it would open many doors to fakes, as well as drawing the bad guys to them.
I may be alone here, but my favorite Bond was George Lazenby in "On Her Majesty's Secret Service." In the film, he most definitely showed true vulnerability and in some scenes, genuine fear.
'Course, Diana Rigg made for some nice eye candy too...