I find some of the Vampire the Masquerade novels pretty good.
If it doesn't have to be based directly on a rpg, I can recommend everything from Tad Williams, especially the Dragonbone Chair saga, which is classical fantasy with great characters and an interesting plot.
