Amusingly, Dwarf Fortress has persistent worlds you can change and Adventure mode to wander around in them. The game balance is a little... off. And you have to make your own goals. But it's an idea you could poke at for a while.