Outer Wilds is the best in class for this genre, IMO.
I really regret ruining Outer Wilds for myself, I had to look up a few solutions because I was very stuck, but I should have kept trying. Part of the issue, which I vow to never have again, is that I kept underestimating the creators, since it was an indie game, I figured that there was some parts of it that might have inelegant solutions, but no, don't make this same mistake! Outer Wilds is perfectly designed. Everything is solvable with in-game clues, but you're going to die many times in the meantime.
An experience i will never forget