Seems like everyone has already said it, but FFX was by far the best in terms of story.
A bit off topic- I think the reason FFXII failed in some respects is because it lacked the love element that FFX had. There was no Tidus + Yuna/ Cloud + Aerith or Tifa/ Squall + Rinoa/ Zidane + Garnet.