And for most cameras, you can buy additional applications to do what I thnk AJ wants.

Not to copy pictures from it as a drive, but to shoot tethered to the computer, and so see the images as they are taken instead of afterwards.

I was able to get that quite cheaply for my Minolta A1, but discovered it wasn't a feature I used very much and so abandoned the idea of getting it for my Canons.