It's all subjective. I find FFXII story better. FFXIII story was entertaining. I also enjoyed FFXIII-2 story as well. They may be not be as good, but I enjoyed both FFXIII story. But FFX is rather mid-tier. As far as FF story goes, I hold Tactics, VII, IX, and XII in high regard.
But I'm more of a gameplay and character kind of guy. So long the story is decent and entertaining I'm satisfied. I don't think most FF have amazing stories tbh. They are all either average or mediocre. I can think of plenty of games with better stories. Xenogears especially makes a game like FFX look like a kid book in comparison.