Well, no, not actually James Bond, of course, who according to his portrayal is handsome, hard and masterful with women. My favourite spy, on the other hand, was short, slightly built and didn't look as though he could punch the skin off a rice pudding - and he was Spanish. His name was Juan Pujol Garcia and I wrote about him back in 2011. He was, by all accounts, the greatest double agent the British ran during WWII. He succeeded in convincing German intelligence that he was running a web of pro-German traitors buried in the British government and armed forces. This 'phantastical' creation was so realistic that the German High Command came to rely on it and when Garcia carefully dribbled through information to the effect that the real Allied objective prior to the invasion was actually the Pas de Calais, not Normandy, they swallowed it whole and diverted troops, especially tanks, to protect the area thus keeping them well away from the actual landings.
But there was one potential snag - his 'missus'! She, too, was Spanish and for some reason she really didn't find life in Hendon very exciting! In fact, she was desperate to go back home to sunny Spain and she gave poor old Juan real 'ear-ache' on the subject, even threatening to spill the beans on his giant double-cross if he didn't take her back home.
A certain 'Mr. Harris' of MI5, Juan's controller, was forced to take some exceedingly clever steps to persuade Senora Garcia that it would be, er, unwise for her to carry out her threat. The Daily Mail has the full story and it's worth a read. Somehow, one feels, James Bond would simply have snapped her neck and tossed her in the Thames!