WIA-Loader offers the possibility to directly control cameras that have a WIA or WPD driver (or that are connected via PTP/IP over WiFi, see WiFi capable Nikon cameras). You can take single pictures or series of pictures, optionally with a live view of the camera image, and directly import them with your import profiles.
If your camera allows controlling the exposure parameters, WIA-Loader can be used to do exposure bracketing.