Spore without a doubt was probably my biggest disappointment ever.

Deus Ex 2 also runs pretty high on that list. I'd have to agree that FFTA was a let down after FFT. I wasn't let down by FFXII that much. I loved the feel of the game as far as the battle system went all how large the world was with so much to do, but the story felt lacking and fell flat with me.