Also open to recommendations re sci-fi books.

Nothing that spans 20 novels and has 4000 different characters.

@TimeSnow looking at my shelf... Asimov, obviously. Some KS Robinson - Mars Trilogy is very good, but he also wrote stand alone novels. Andy Weir's Martian was à blast.