Spider Man 3, Final Finasy: advent children, and some other shows that let people dpwn. Some people were looking forward to Spiderman3 and FF:Advent Children, but they turned out to be really disappointing.
FFVII: was 'good' if you consider that all ti was truly trying to accomplish was the usage of certain character's faces in a quick-buck earning venture. The CG was impressive and the fight scenes were good.
however, from a director's and even a writer's point of view, it seriously sucked as a story.
The movie IMO is ok for it's own rights, but as part of the Final Fantasy series, where's the connection? At least that's how FFVII - Advent Children became great because it explains what happened after the FFVII game.