The Secret of Mana had a two player option, but I don't know how widely used it was. Playing that game with two or three players was a dead solid blast, by far my favorite SNES experience.