This film was so unfairly treated on it's release, it fell into being thought of as a cartoon that wasn't for kids and because of that it had poor box office.
It was, in fact, a fantastic sci-fi adventure way ahead of it's time. Just think how amazing it would look using today's 3D technology. In saying that, it still looks pretty fantastic.
Don't let the Final Fantasy name put you off either, it has nothing to do with the video games, it's an original story and features the voices of Alec Baldwin and James Woods among others.
Check out this cool trailer.