IMO most of the lore is in the physical novels and later games that go more into story. Myst and Riven sort of drop you into an existing universe without explaining much and then you can learn some through bits and pieces as you go.