My takeaway on Bond is that he's way more interesting as a flawed protagonist, much in the same way Fleming himself was. Through the movies, he became symbolic and idolized in a way that I don't think Fleming intended.
The Casino Royale movie reboot was pretty great IMHO. The direction Bond is going now is pretty hit and miss. I'm guessing every few decades we'll need to tear down the mythology and start over with something better grounded in reality, and give a reminder of how imperfect Bond can be.