"Childlike wonder" is an interesting turn of phrase here, that reminds me of one specific game — Outer Wilds. The way I like to describe Outer Wilds is that you're exploring the star system in your grandma's back garden, escaping a blackhole just in time for dinner.
Everything about the game seems designed to elicit that response. The in-world technology is absolute jank, with wooden spaceships and patched-over spacesuits. Both groups of aliens in the game (the Hearthians and the Nomai) are intensely curious and driven by wanderlust. The story's stakes are simultaneously enormous and none at all, like a child playing make-believe.
Playing it genuinely gets me feeling like a child, and that's something truly special.
One of my favorites as well. A folk space exploration sim. I did find a few of the puzzles a bit too difficult though.