I liked the story overall, which is usually the case for a Final Fantasy, but SE have always had a problem with the scenario writers ever since voice acting was introduced. The FF game that did scenario writing the best was IMO actually XII.
So its like, some of the individual scenarios are pretty cringe-worthy but I really liked the plot overall.