This is a really excellent resource for any DM running a campaign in Waterdeep, especially Dragon Heist. It contains information on every building in Trollskull Alley and almost every one has multiple adventure hooks that are, for the most part, solid gold. There's a pirate, a necromancer in the basement, a Vistana, and so much more. It's supplemented by a huge variety of color maps of the alley and every place in it. This supplement does a LOT to bring the alley to life, and in my opinion, succeed marvelously.
My only complaint, and it's small, is that the supplement is tonally inconsistent. There's some pretty dark stuff here, but also a few groan-inducing pop-culture references, and the adventure hooks veer between the extremely minor to the enormous, with little middle ground.
That quibble aside, I definitely recommend this and have incorporated it into my own Waterdeep campaign.
[5 of 5 Stars!]