I second Shadows of doubt. I haven’t played the release version yet (I’m still building factories in Satisfactory) but I can give my most memorable detective work from early access. I was doing side jobs because my murder case had gone cold. I had a gig where I needed to find proof that the clients partner is having an affair. The information I got about the potential lover were some vague physical traits like eye color and shoe size. But the key information was that the lover’s partner worked as Wait staff. So I

1. went through every restaurant, bar, diner etc in the city.
2. Got a list of every wait staff member.
3. Found out where they live.
4. Broke into their house.
5. Found their partner information.
6. Found the potential lover.
7. Started looking for key evidence to tie them to the affair.

The last step is where my gig ended up in a roadblock. I’m not 100% sure but I think it was bugged because I did everything I could come up with. I went through the clients partner personal stuff and found nothing. I went to their work and found nothing. I went through the lovers personal stuff and found nothing. I went to lovers work and found nothing. I even planted a tracker on both of them and followed them around to see if I missed something and I still found nothing. I even checked the mailboxes. So the key evidence was probably bugged and I couldn’t find it.

Despite that I haven’t had such a unique experience in any other game. It’s up there in my backlog waiting for me to return, but first the factory must grow.