The greatest piece of games writing for me is the worldbuilding of Sid Meier's Alpha Centauri, through the informative texts for buildings and technologies.

Direct narrative in games is very tricky, because it can conflict with player agency.