https://www.thetrekcollective.com/p/trek-lit-reading-order.html
The site above has a handy flowchart that covers a lot of the basic ordering of events and series from the last 20 years. If you liked the Cardassia/Andor book, the other two Worlds of DS9 books should be right up your alley. Taking Wing, the Destiny trilogy, A Singular Destiny, the Cold Equations trilogy, and the Plagues of Night/Raise the Dawn duology have some major impacts on the post-Nemesis galaxy and are well worth reading.
I just finished up a reread of Before Dishonor. I loved the book on its initial release, and it still holds up today. There are a lot of great character moments and plot developments, and the pace is breakneck near the end. I recommend it even more highly for fans of Picard, Worf, Spock, Seven, and Lady Q.