I don’t know if the CIA used him or not, but being a nut does not preclude them from doing so; it probably makes him more desirable to them.
If you want something done do you really hire and invest all the costs and effort in grooming and modifying people who can’t accomplish anything and then wait for the fallout from their interrogations, prison years, lawyers and investigations by authorities, book authors, and journalists?