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...
He was very good, and OHMSS is still my fav. Though Casino Royale and Skyfall were superb.