The problem with this movie is that hardcore fans are expecting EVERYTHING from it.
From Cloud and Tifa kissing to the end of the world at the hands of Jenova...OK, now I exaggerated, but you get the point, don't you?
The trick to enjoy it is: always keep in mind that it's just a movie. It has a 100 minute span. There can't be everything everyone wanted in it.
I went to see it never forgetting that and I enjoyed it a lot, because I kept my expectations low and so it proved better than expectations.