How about books with Chekov, Uhura, Data, Dr. Crusher, Wesley, Troi, Jadzia Dax, Worf, Chacotay or any other person in supportive roles in the shows? Thanks.
There is a Next Generation era book called Imzadi that features Data as a captain of a future version of the Enterprise. It's an alternate universe/reality story and a time travel story. It's really good. It's about an elderly Admiral Will Riker using the Guardian of Forever time travel device to fix something that went horribly wrong in his reality. An adult Wesley Crusher is also captain of another vessel in this book. In the Voyager re-launch novels that were published after the series ended. Chakotay is made captain of Voyager with Paris as his first officer eventually after Janeway becomes admiral.