The suspicious death of a sex offender raised investigators' eyebrows, but it was his partner's new boyfriend, a $110,000 insurance policy, and an unusually intense fire that led them to the truth