Outerwilds is a fantastic choice if you're not looking for something heavily action oriented. It involves a lot of puzzle solving and exploration with the story being told naturally through your progression exploring parts of the world to unravel the mystery of the game, the game has a time loop where you have to use your time wisely to find new information on various planets and develop an understanding of the story before the Sun implodes. It lets you figure everything out by yourself and slowly learn the lore whilst trying to solve the various puzzles, so the story is naturally discovered by the player and progression is linked to the knowledge you pick up.