I'm seconding the Destiny Trilogy by David Mack recommendation. It's what got me back into reading Trek. Fair warning though it's set after Star Trek Nemesis and the finale of Deep Space 9/Voyager plus the post finale DS9 relaunch books so be prepared to either read a ton of books before the trilogy itself or at least browsing the wikipedia entries.
I'd also recommend hanging out at the
http://www.trekbbs.com/ too. They have a Trek Lit section where you can interact with a few of the current Trek writers including the aforementioned David Mack.