Enevhar Aldarion
Hero
FWIW Dragon Heist is currently polling at 58.5% here on EN World. Of all the official 5e hardcover adventures, only Hoard of the Dragon Queen has a lower score and not by much (52.5%). Granted DH is still one review short of being certified; nevertheless, I think it is fairly telling that it is currently the second least-popular hardcover adventure.
But is that score because there is not much actual adventure in the book or because it is a bad adventure? It is basically the same shortish adventure that can be played in each of the four seasons and with a choice from four different BBEGs at the end. And from what I hear, you do not actually fight any of the BBEGs because your group is level 5 at the most when you get to the end. Just that alone could get a lot of people to give it a poorer score than it deserves because they cannot just go in and kill everything that gets in their way. Which is also true about Waterdeep in general. That must frustrate a lot of gamers out there who are not used to controlling and restricting what their characters do. So maybe what is "fairly telling" is that a lot of the reviewers play murder hobos.