I don't know about the rest of the games in the series, but FFVI supports two players. you can assign who plays which of the four players in battle on the configuration screen.

And I agree with DocFrance; I think that it would be boring.