The expensive new movie was a total damp squib.
damp squib
idiomAnything that does not work properly, or fails to come up to expectations; a dud.
Everyone expected the grand opening to be exciting, but it turned out to be a damp squib.
Despite the massive marketing campaign and high expectations, the product launch proved to be a damp squib that failed to capture the public imagination.