Well, the FFIX Moogles where certainly the most useful, in that could save the game for you and all that.

They probably had the most personality in that game to, thanks to the mognet system you see how each moogle interacted with each other, FFVI came close by having a moogle as a character, but he wasn't executed that well as character in my opinion.