Johnny Roselli, and Sam Giancana were really the only ones that have been named that were really linked to the CIA. they were in on the failed attempted assassination of Castro
If my memory of the Chruch Committee hearings is correct:
Santo Trafficante was introduced to Robert Maheu during the discussions to kill Castro.
Maheu worked at FBI and CIA and later worked for Howard Hughes. I believe he was also a devout Mormon.