Definately not an Ed Greenwood novel. He may have created the Forgotten Realms, but as a novelist he leaves a lot to be desired. Having said that, he praised The Last Mythal by Richard Baker as being one of the best Realms books he had ever read, and I pretty much have to agree with him.
Elaine Cunningham should be made to write Realms books for the rest of her life, she is that good at them. Elfshadow is her first and still probably the best (not read her Magehound trilogy or Evermeet yet). Others I'd recommend are:
The Parched Sea by Troy Denning
Red Magic by Jean Rabe
Crypt of the Shadowking & Curse of the Shadowmage by Mark Anthony
The Rage (Year of Rogue Dragons book 1) by Richard Lee Byers