The story starts off well enough, but it does meander toward the end, and FFXII has one of the poorer endings of the series. It's all the stuff in between, though, that makes FFXII a great game.
You didn't like the ending? I thought it was the most emotional scene in the entire story.