The Roottrees Discord community collaborated on a great list of detective and mystery themed games with detailed notes: https://docs.google.com/spreadsheets/d/1aLkcWVk0FBJpLsHBf3SH0CEVvc7LpP0lqx9oGc9__IU
Detective & mystery-themed puzzle games

Google Docs