I used to know a guy who flew with the FBI out of NAS Lakehurst in NJ, and he seemed to like it alot. He got there after flying KC-135s in the USAF for about 8 years, so he was a pilot first.
He took me flying a couple times in his Yak-52 back when I worked at Marlboro airport in summer 2000. In 2002 he was severely injured when he crashed that plane on takeoff, but from what I heard he got to keep his job flying at the FBI.