James Bond is perhaps the greatest spy ever on screen, but let's not kid ourselves that he's always the brightest tool in the box.