I have been shooting tethered using Lightroom for a couple of years with mixed results. Sometimes it recognizes my D800 sometimes it doesn't. I do a fair amount of corporate work where executives want to see what I've shot so I'm looking for an alternative to LR or suggestions that will give me better results with LR.
I just use the USB cable that came with my D700. I have both USB 3 and USB 2 ports. Don't really see any problems. I just know I am happy with the Nikon product as it takes advantage of all the camera features. I think there is a trial version you can try. Other advantages is it allows you to sync the camera and computer data as well.