When was James bond perfect? He gets caught, betrayed, tortured, outsmarted in many movies before Casino Royale. He is deeply flawed as well.
I actually think James Bond doesn't work in a realistic setting. It just becomes a random action movie like what we've seen during the Craig's Era.
I just finished a full rewtch of the 25 movies and it's crazy how enjoyable the "old" ones were compared to the reboot. I remember my wife telling me during Quantum of Solace "I guess now it's more Jason Bourne than James Bond".