I feel like very few games throughout history seriously attempted to recreate the experience of an actual adventure

Most quickly devolve into chore simulators, and the ones that don't, like JRPGs, feel like linear hallways