PS3 pad can only sync over USB, so that is probably a none starter.
Xbox pad is not Bluetooth and so needs the USB dongle, so again its a none starter (as the N900 does not support USB in that way).

So far Wiimote is confirmed as working at least with the SNES emulator, Zeemote will probably also be supported. Other than those, its anyones guess.