Are Real CIA Agents As Badass Or Skilled Killer As Films Like Taken Or The Equalizer Make Them Out To Be?

Since I am more familiar with Mossad rather than the CIA, I will answer from my own perspective and experience about intelligence agents.
Let’s get one thing straight first.
They don’t have any more hand to hand combat skills than a trained soldier, they don’t drive around fancy cars wearing fancy clothes, they don’t try to look good and they are certainly not involving any affairs with cute women on their missions.
An agents greatest skill is being unnoticeable. Once he is invisible, he can do anything he wishes. To achieve this, an agent cannot look suspicious and cannot grab attention. He needs to blend in with the public as best as he can