My related memory of the Avatar trilogy was our experience of playing through those
terrible modules. We had already played
Curse of the Azure Bonds, and it worked because it was set up as a parallel story to the one told in the novel.
The Avatar modules were designed so that you ended up traveling with Midnight, Kelemvor, Cyric, etc. and bearing witness to their ascension to godhood. Total railroading. very boring and frustrating to play, although I actually
liked the whole concept of the Time of Troubles.
Anyhow, when we got blamed for Elminster's death at the end of module 1 and all our gear was taken and we were thrown in jail, another player started going off about how terrible all of this was. I thought it was so obviously engineered that I leaned over to him and muttered cynically, "Don't worry...the module will protect us."
The DM got pissed, but luckily we didn't go on to Tantras and Waterdeep.
Oh, yeah...on topic, I used to read FR novels.
Icewind Dale trilogy was okay, and so was
Azure Bonds, when I was in high school. Tastes change. I recently read
Death of the Dragon and found it irredeemably sucky for anything but background info about Cormyr.