Yes, Azure Bonds is excellent fun classic early Realms stuff. Gleefully high magic and eccentric, and I have a great deal of affection for it.
The Brimstone Angels books get extremely good reviews (like 'some of the best FR books ever written' type reviews) but I can't attest to them personally cos they're from the 4th ed era when I wasn't really in the hobby.
War of the Spider Queen are a multi-author project and are a mixed bag accordingly, and being a long series the inconsistent characterisation doesn't do them any favours either. I was pretty burnt out on all things drow by the time I read them, but I didn't really get into them at all. Evil/antihero protagonists just not my bag.
Ed Greenwoods work is of course monolithic in the history of D&D, but Elminster and the Elminster books you either love or hate. Not really even vaguely related to D&D game mechanics or player experience at this stratospheric power level, Ed Greenwood has a very distinctive writing and plotting style that leaves nobody neutral. Makes no attempt to dispel the ''Mary Sue' allegations, wild and loosely plotted, rollicking hail-fellow-well-met and a perhaps implausible number of hot magic women wanting to sleep with the crumbly old beardy guy.
Star of Cursrah and Lost Library of Cormanthor are standalones and relatively low-stakes ones on the Realms scale of such things, but from memory they're both ok.
The Halruaa books are a tad odd. Elaine Cunningham is a good writer and it’s an interesting, rarely-seen part of the world but personally I found the pacing and structure a little jarring and the conclusion not terribly satisfying. There’s a lot worse Realms books out there, but just - hmmm.