chronoark lets you die and counts your deaths for you.

anything agatha christie/ hercule poirot is light detective work (good for kids and or newbies) with optional handholding

i remember there’s some good mystery modules with neverwinter nights

morrowind quests don’t coddle at all. they all look like journal entries.