The Book of Unwritten Tales comes to mind. It’s nowhere near as grandiose as any of your described games, but I fondly remember it being a very charming and wholesome experience. If that’s the feeling you seek, you might enjoy it.