Of what i heard about it, FFXI have a great story with good characters(NPCs) and each game have an "end"(they even have final bosses). But it's online, and many people choosed not to play the game because of that. Hell, some people even think that it cannot be considered a FF.
FFXI is the most underrated game in the series by far.