Related, somewhat opposing question: did we ever have cool spies? My impression was that Roald Dahl, etc. were the exception by far, and that most ordinary spies (and spycraft) came down to being a bureaucrat and dealing with bureaucracy.