WatchMojo: "Top 10 Reasons James Bond Is a Terrible Spy"
Without even watching that video....
First, he's not so much a spy as a hit man for the government. He does no intelligence gathering or anything we'd normally associate with espionage.
With that out of the way, he makes ZERO effort to be inconspicuous. He even uses his real (well, the one he has for paperwork purposes) name!
At least in the Connery era they made some pretense of "There's something unusual going on here. Go find out what it's all about. If you get the opportunity to stop it by killing someone, well, we'll look the other way."