I haven't read a lot of gaming fiction.
I've read the first two Dragonlance trilogies. Good stuff, that; I still enjoy the first three best.
I've read the Icewind Dale trilogy. Not too bad; I'll try some more at another time.
I haven't been interested in most of the books that WOTC has put out; for the most part, they involve characters and races that I just can't see myself enjoying. It seems like they go out of the way (possibly to avoid stereotypical 'party' makeups?)to include the most bizarre combos of races they can come up with.
I keep hearing Elaine Cunningham is the person to read. Tried Dream Spheres a couple times, but can't get past the first few chapters. That's not unusual; I have that problem with non-gaming books from time to time.
I might look harder at some of the books in the Rogues series, since generally I like the class a great deal; none of the ones I've seen so far really strike me as something I'd want to pick up.
I did read Spellfire, and for a long time it was one of my favorites. Not because of plot or characterization; to this day I can't tell you the plot, beyond 'it was about some woman with the ability to weild Spellfire'. What I loved was the dialogue. If I was going to run an FR game, I'd go back and read this again, to pick up how they speak the language there. That was utterly fascinating.