I have not tested this myself, but it should be possible to connect one SNES and one NES controller. The recent version of SNESDev, the driver for the RetroPie GPIO Adapter, can be configured in this way.
Four game pads would need four data lines, which are not provided by the adapter at the moment, unfortunately.
