Glad to help.Hi there,
Looking for a favour, here's the list of all the books I can find that are Forgotten Realms, my to-read list right back at the start of this.
I've added a section at the bottom of other books I need to fir into the list.
Have I missed any?
Any other obvious errors, exclusions, inclusions or whatever- I just want to get it as right as I can?
Thanks for taking the time.
Stay safe and well you lovely people.
Looks like you're missing Ed Greenwood's Spellstorm and the past seven Drizzt novels—Archmage, Maestro, Hero, Timeless, Boundless, Relentless, and the just-released Starlight Enclave.
Four of the short stories (out of twelve total) in the paperback short story anthology Untold Adventures from 2011 are set in the Realms.
You're also missing a number of short stories published over the years in Dragon magazine and never reprinted elsewhere—some of them quite excellent, and several of which are directly tied in to books that are on your list, such as Byers's Sembia tie-in "Shamur's Wager" and Kemp's Erevis Cale origin story "Another Name for Dawn."
Some Realms fiction has been published more recently as e-exclusives in Dragon+. And Greenwood has published a short story on the DMs Guild entitled "Umbrous Unpleasantness at Undreth's Unicorn."
There's also the matter of the various comic books; these are of course another kettle of fish, but for the most part they're not too bad, and the characters and events of several of the series are referred to in later prose fiction and in the sourcebooks. The key series would be the two '80s DC Comics series Advanced Dungeons and Dragons (set in Waterdeep) and Forgotten Realms; and more recently, from IDW, A Darkened Wish and the five (so far) Baldur's Gate miniseries with Minsc. But there have been others, such as Salvatore's Drizzt tie-in series Neverwinter Tales and Cutter. All of these are available in paperback collected editions. (There have also been some comics adaptations of prose fiction, including adaptations of the first six Drizzt novels; these may be safely skipped.)
Salvatore's "If They Ever Happened Upon My Lair" is a short story included in the Drizzt Collected Stories volume, so I'm not sure why it has a separate entry.
Also, it's not an error, and you might already be aware of it, but most of the Abyssal Plague novels aren't set in the Realms; only Sword of the Gods and Shadowbane are Realms books. This was a multiversal crossover series, with novels set on Athas, Nerath, the outer planes, etc. It's along the same lines as the six-book Spelljammer series "The Cloakmaster Cycle"—but come to think of it, there's probably a better argument for including all six of the Cloakmaster books than there is for the Abyssal Plague books, since unlike Abyssal Plague the Cloakmaster books do tell a continuous story even though only one of the Cloakmaster books is set entirely on Toril.
You might be aware of this too, but a number of the late-4e-era books were e-book exclusives. This includes the aforementioned Shadowbane and its sequel Eye of Justice, along with several others such as Cold Steel and Secrets, Sword of the Gods: Spinner of Lies, Prince of Ravens, and Spider and Stone. So don't pull your hair out trying to track down hard copies of those.
I can't promise there isn't something I've missed, but I've tried to be thorough!