If you set up an iCloud account, then that overnight syncing is done over WiFi to an Apple Server, not your computer. Your thinking of Over-the-air syncing, which is done locally between your iPhone and your computer, but only when you want to add new media/apps to your device like you do now, but without the USB cable.
and like andythursby said, Free WiFi at the Apple Store.