Tbh I've done it in Brindlewood Bay, which just has a structure for running murder mystery where players have to gather clues, then put together a theory on who and how commited the crime, and only then do you roll to see if the theory is right. Yes, the mystery doesn't have a solution at the start.