The catch is, Realms adventures fell into two camps:
The first was the super generic adventures, as FR was taking over Greyhawk's place in the '90s as the location of generic adventures.
The second was the "living" stuff you mention where events advance the world. The Avatar adventures. The Horde adventures. The Spellplague adventures. The Sundering adventures.
The former tend to be less memorable. Just because they're competing with twenty years of older generic adventures.
The latter don't make good APs since their stories already "happened".
There are a few. Ruins to Undermountain kinda counts, and its sequels/ revisits. It's the most likely as it was touched on in Expedition to Undermountain in 3e and Halls of Undermountain in 4e.
Bloodstone Pass is another. How the Mighty Are Fallen is neat but set in the past; could be fun as a time travel tale. There's the Marco Volo adventures. Pool of Radiance is an iconic name, being a video game and novel prior to a 3e adventure.
City of the Spiderqueen is likely too simmilar to Out of the Abyss to do anytime soon, but a drow centric adventure with Lolth is needed.