USB will work fine for your purposes, and should work with any DAW with no need for special drivers or other software; USB-over-MIDI support is standard on any recent OS.
The one significant drawback, which isn't a problem in your case, is that keyboards with only USB can only connect to a computer, not to another MIDI device. So, for example, if you want to use one as a controller to play sounds from another synth, then you could plug both devices into a computer and use software to route MIDI from one to the other, but you won't be able to leave the computer at home entirely.
(Note that a number of keyboards have USB host (type A) sockets like the ones on a PC, which makes it physically possible to connect the keyboard to another keyboard with a device (type B) socket. But it won't work. Those sockets only support storage, usually to back up patches or recordings on a flash drive. I believe the only current exception to that rule is the Korg Kronos.
So, if you're buying a keyboard, and want to be able to connect it to another piece of MIDI hardware that's not a computer, then the keyboard should either be a Kronos or have real MIDI ports.)