Not an RPG but has a lot of lore and a form of exploration: Talos Principle 1 & 2.

Hands down the best puzzle games I’ve ever played.