Well, I read up that when Advent Children was made, Nomura wanted the film to be a different path far from the Western films and have it filled with loaded questions and when fans finish watching it, they were to enjoy it and talk to friends about their own conclusions.
But it was still better than Final Fantasy: Spirits Within, they say.
I'm not sure if I'm wrong, I'll have to check it up again, but I think I read up that Before Crisis was a success in Japan for mobile gamers or the opposite.
Dirge of Cerberus was a bit of a bomb due to the Gun-Fight role play, but it was a cool story.
Crisis Core was a success of course. But then again, it's ending which was the opening of the original game is what made everyone demand for the remake because of the graphics.
I'm probably wrong, so I'll double check.
Edit: Went back and it's confirmed that Before Crisis was highly popular in Japan, and on the first day of operation, 200,000 gamers registered and was accessed 1.6 million times back in 2004 and was still highly popular in 2006. It was actually this game that led to the creations of Type-0 and other Final Fantasy mobile titles today.