I reject the the idea that these types of people are needed. It's probably that most of the people in the CIA happen to be like that because they're power-hungry and they're just selecting their kin and justifying their choices as "right kind" because they narcissistically believe themselves to be the right type... They're probably the wrong type. Especially if they all share narcissistic or psychopathic traits; it's too many, it cannot work.
The company hires people who match the company’s desired culture.
If the people in the CIA who do hiring want the talent who are excellent at lying and compartmentalizing their ethics, then that’s what the organization becomes over a generation.