If you’re not just looking for novels I would like to highly recommend two non-fiction books: “The Fifty-Year Mission: The first 25 years” and “The Fifty-Year Mission: the next 25 years” by Mark A. Altman and Edward Gross. The books tell the oral history of Star Trek up until 2016. They consist entirely of interview snippets from cast and crew, sorted chronologically and thematically. It’s a super interesting look behind the scenes.