Are there any differences between what can be done with a mobile device (smartphone or tablet) connected by Wi-Fi (wireless) and with a USB (wired) connection?

No there aren't.

With either method of connection, rekordbox (iOS/Android) installed on the mobile device can be used for DJ performances using the tracks on the mobile device.