From presidential briefings to bestselling thrillers, David McCloskey reflects on espionage, morally complex characters and storytelling