Basically every movie with any CG in it was done in Maya or 3DSMax, although some things are done in Cinema4D (Mostly because of bodypaint.)
Square does basically everything in Maya, so you don't need to look any further than Advent Children, FF:TPW, or the cutscenes in the recent Final Fantasy games.