@swan_tower If you like mystery, Hercule Poirot: The First Cases is a mystery adventure game with the usual investigative elements including searching for physical clues, interviews, and a mystery-solving mechanism that involves drawing connections between clues to reach conclusions. No speed/coordination challenges at all. The overall game isn't very long and is divided into several chapters.
In the same vein, if you haven't played them yet the early Phoenix Wright games (like the first three) are really good examples of puzzle-mystery adventure games. Very fun if you can ignore the weird law and judicial shenanigans xD Length-wise I don't recommend the Chronicles games--so much dialogue and so long ugh, though I did enjoy them overall and the historical elements were nice.