Charlie and the Chocolate Factory, Groundhog Day, Catch Me If You Can, Bullets Over Broadway. Big screen-to-stage adaptations of beloved IP with prestigious creative teams that looked like big hits on paper but didn't last a year in NY.
I really don't think Be More Chill belongs on this list. Sure, it's a big flop, but I wouldn't say it was "much anticipated": It was a first-time Broadway creative team, it got awful reviews off-Broadway, the producers and theatre owners took a risk to transfer it, and it tanked, but is only a $9mil loss compared to the much higher budgets for the shows above. It's more in line with shows like Bright Star, Bloody Bloody AJ, Head Over Heels, and Amelie.
Re: the Addams Family post --- yes it got awful reviews and wasn't profitable on Broadway, but it came close to recouping in NY, the tour did well, and it eventually made profit with international productions and stock/amateur licensing. Not a juggernaut, but also not a King Kong.