It doesn't always go bad. I worked for the Secret Service for two years as a CI. At the end they screwed me out of a few hundred dollars but I also didn't have to serve the eight years in prison I was facing. They never asked me to rat on someone, I built up new online identities and trained them.