A former (1989-94) head of MI6 (Britain's overseas intel agency) admitted what many long suspected, that fictional MI6 employee James Bond was good for recruiting, and the MI6 image in general. To a lesser extent, so were other fictional portrayals of MI6 (like John Smiley, in the le Carre books) that were less flattering.
MI6 discovered that James Bond, for all his silly fictional flaws, gave MI6 flattering public recognition. This enabled MI6 to recruit better people, more easily. Those who were suitable for MI6, were quick to appreciate that Bond's escapades were more entertainment than real, but all those Bond movies ensured that MI6 recruiters didn't have to spend much time explaining who they were, and what MI6 did.
Actually, it was the le Carre books that gave a more realistic description of the drudgery and boredom of real espionage operations. But that also helped with recruitment, as serious candidates were quick to discover that le Carre was more non-fiction than fantasy (which Bond eventually evolved into.) MI6 personnel sometimes get nervous about how accurately le Carre portrays their tradecraft, but the spy business is a rapidly evolving enterprise, and le Carre is always at least a few years behind the latest innovations.
When it comes to gadgets, James Bond has actually demonstrated several actual, or planned, spy gizmos. That aspect of espionage work is real, but it plays a much smaller part in operations than Bond's antics would have you believe. Within the intel community, the main enthusiasm for Bond is related to the much improved image the fictional swashbuckler gives to members of a very secretive profession.