Here’s an incomplete list of the main line Star Trek novels set in the 24th century, after TNG, DS9, and Voyager. I’ve starred my personal favorites of the ones I’ve read.
Star Trek: TNG novels set after the series:
Before Nemesis
[ul]
[li] A Time to Be Born John Vornholt *
[/li][li] A Time to Die John Vornholt *
[/li][li] A Time to Sow Dayton Ward and Kevin Dilmore
[/li][li] A Time to Harvest Dayton Ward and Kevin Dilmore
[/li][li] A Time to Love Robert Greenberger
[/li][li] A Time to Hate Robert Greenberger
[/li][li] A Time to Kill David Mack *
[/li][li] A Time to Heal David Alan Mack *
[/li][li] A Time for War, a Time for Peace Keith R. A. DeCandido
[/li][/ul]
Post-Nemesis
[ul]
[li] Death in Winter Michael Jan Friedman
[/li][li] Resistance J. M. Dillard
[/li][li] Q & A Keith R. A. DeCandido
[/li][li] Before Dishonor Peter David
[/li][li] Greater than the Sum Christopher L. Bennett *
[/li][/ul]
Destiny and Aftermath
[ul]
[li] Destiny Book 1: Gods of Night David Alan Mack *
[/li][li] Destiny Book 2: Mere Mortals David Alan Mack *
[/li][li] Destiny Book 3: Lost Souls David Alan Mack *
[/li][li] Losing the Peace William Leisner
[/li][li] Indistinguishable From Magic David A. McIntee
[/li][/ul]
Star Trek: Titan (Riker’s ship)
[ul]
[li]Taking Wing Michael A. Martin & Andy Mangels *
[/li][li]The Red King Michael A. Martin & Andy Mangels *
[/li][li]Orion’s Hounds Christopher L. Bennett *
[/li][li]Sword of Damocles Geoffrey Thorne
[/li][li]Over a Torrent Sea Christopher L. Bennett *
[/li][li]Synthesis James Swallow
[/li][/ul]
Deep Space Nine novels set after the series:
[ul]
[li]Avatar, Book One S. D. Perry *
[/li][li]Avatar, Book Two S. D. Perry *
[/li][li]Mission Gamma: Book One Twilight David R. George III *
[/li][li]Mission Gamma: Book Two This Gray Spirit Heather Jarman *
[/li][li]Mission Gamma: Book Three Cathedral Michael A. Martin and Andy Mangels
[/li][li]Mission Gamma: Book Four Lesser Evil Robert Simpson
[/li][li]Rising Son S. D. Perry *
[/li][li]Unity S. D. Perry *
[/li][li]Worlds of Deep Space Nine: Volume One Cardassia & Andor Una McCormack / Heather Jarman
[/li][li]Worlds of Deep Space Nine: Volume Two Trill & Bajor Andy Mangels and Michael A. Martin / J. Noah Kim
[/li][li]Worlds of Deep Space Nine: Volume Three Ferenginar & The Dominion Keith R. A. DeCandido / David. R. George III
[/li][li]Warpath David Alan Mack
[/li][li]Fearful Symmetry Olivia Woods
[/li][li]The Soul Key Olivia Woods
[/li][li]The Never Ending Sacrifice Una McCormack
[/li][/ul]
Voyager novels set after the series:
[ul]
[li]Homecoming Christie Golden
[/li][li]The Farther Shore Christie Golden
[/li][li]Spirit Walk Book One: Old Wounds Christie Golden
[/li][li]Spirit Walk Book Two: Enemy of My Enemy Christie Golden
[/li][li]Full Circle Kirsten Beyer
[/li][li]Unworthy Kirsten Beyer
[/li][li]Children of the Storm Kirsten Beyer
[/li][/ul]
Misc. novels that fill in some of the back story of Destiny:
[ul]
[li]Articles of the Federation Keith R. A. DeCandido
[/li][li]A Singular Destiny Keith R. A. DeCandido
[/li][/ul]
Typhon Pact (post-Destiny arc):
[ul]
[li]Typhon Pact Book 1: Zero Sum Game David Mack
[/li][li]Typhon Pact Book 2: Seize the Fire Michael A. Martin
[/li][li]Typhon Pact Book 3: Rough Beasts of Empire David R. George III
[/li][li]Typhon Pact Book 4: Paths of Disharmony Dayton Ward
[/li][li]Typhon Pact Book 5: The Struggle Within Christopher L. Bennet
[/li][/ul]
Again, this is an incomplete list. I’ve left out some of the mini-series like New Frontier and Starfleet Corps of Engineers and the short story collections (worth a read, by the way).
For a more complete list, check out Memory Beta, the non-canon Star Trek wiki: http://memory-beta.wikia.com/wiki/Main_Page
I can also highly recommend the Star Trek: Vanguard series (set during TOS) and the post-Enterprise Romulan War books if you’re interested in that era.
Enjoy and happy reading!