The most recent detective game I played (if it qualifies as such for you) was Paradise Killer, which surprisingly I enjoyed quite a bit. Again though, the lore has close ties to the interpersonal relationships of all the characters on the island.