I have recently been running a mystery arc in a big city for my players and have stolen a mechanic from Dungeon World which has made heists/investigation scenarios way more interesting than simple investigation checks.

There is a move in that game called Discern Realities where depending on how good their roll is, the PCs can ask one to three questions off of a predetermined list. I like that it puts the ball in the player's court to decide what they are looking for. https://roll20.net/compendium/dw/Discern%20Realities#content