Hmmm…
About 10 years ago, I started prepping the 3.5 mega-adventure Expedition to Castle Ravenloft.
My initial read-through was very positive. I’d successfully run the original 1983 AD&D module I6: Ravenloft a few times over the years, (a 3.5 conversion of the original was central to the revision), and thought that the build-out from there looked like a lot of fun!
But then I started reading it closely to prep for running it, I realized there were a LOT of glaring problems with it. First of all, it seemed to be a hodgepodge of various incompatible horror tropes thrown together, rather than an extended rumination on Gothic horror that I wanted to run. I spent a good month re-tooling it, and eventually gave up. I ran Paizo’s “Rise of the Runelords” adventure path instead.
From what you say, it sounds like Waterdeep: Dragon Heist might have the same issues of too many writers not pulling off a coherent whole!
Oh… and if I’d known ahead of time that becomming owners of a tavern was an integral part of the adventure, I would have brought in a very different character.
That said… I am still having fun!
Oh… and on Ravenloft… I have a copy of the 5e Curse of Strahd, and I think it’s a much better expansion of the original than was the 3.5 Expedition to Castle Ravenloft.