Got Nikon D40x working. Did't manage to get D200 working yet.
Macbook / 10.5.2 / aperture 2
Tethering is pretty fast. A 10mp raw via usb - 4 sec + 2 sec for preview
Fast bursts are ok with my Nikon, I think the camera saves to a card first and then copies the files to the computer.
