They're useful, sure, but then I only have to point at Kimahri's blue magic overdrive and shake my head. Easily the worst incarnation of blue magic in Final Fantasy. The Gun Mage in FFX-2 isn't bad, but it has some bad casting times which the alchemist can overcome.
Having said that, the enemy skill materia is a pretty compelling case for best overall materia.