I think there is a significant difference between Bond and the police officer idea (even though Bond himself uses it as a BS cover with Honey).
Bond, I think, is not a bobby - he’s a dragon slayer and comes from the very oldest stories humans told themselves around the fires when something back in the dark cave started to stir. He is every bit as much a mythic figure as the monsters he’s out to fight.
Policemen, policewomen are not just historically a younger presence - their very idea is also modern: basically that humans make their own laws and see themselves to it they are respected. Police is the order we give ourselves, an entity that’s shaped after our ideas to protect us from each other, from the mob we can turn into at a whim.
Both Bond and the heroes of police flicks are characters that invite our identification. But the police officer is a real-world role model we might actually aspire to. There’s a code of conduct, there are laws, a whole assortment of demands society puts on the role of the police. Rightfully so, because in a civilised democracy police is the organ of the state that’s given the most powers to intrude on the lives and rights of the individual. This power must be fully accountable.
Bond in turn is a character we identify with for two hours - recently more like three - but, with the exception of a few people living in their own sphere, rarely aspire to emulate as a role model in the real world. We are fans, we share certain interests to different degrees. But for the most part we don’t slay dragons. And those who do tend to avoid the Bond connection. If somebody was in fact looking for a career with intelligence services they’d probably better keep mum about their Bond hobby because that’s likely to be the first dealbreaker.
Which illustrates why our depiction of the police in popular culture poses a problem for the real world: there are now countless pieces in newspapers where real world intelligence bosses state they are not looking for ‘the Bond type applicant’ - but pretty few where police chiefs refuse the fans of popular action fare as not fitting into the force.
In turn this poses further problems. When we depict police actions along the lines of ‘whatever it takes’, when we depict a ‘war on the streets’ then we’ll automatically reap applicants who are willing to do just that, whatever it takes. And lying to Internal Affairs and DAs seems really small fry in the greater scheme of things, that ongoing war these officers fight - and to an alarming extent with actual military grade weapons and tactics. What can we expect if we deck out police like infantry? What kind of policing would we expect from, say, special forces? Probably one with a certain amount of collateral damage.
Add to this the military esprit de corps and you can easily arrive at SS-style policing.