It does depend on the camera. Some cameras just don't show as drives.
If you're asking because you wan to be able to drag selected pictures off rather than using iPhoto to get everything, consider using Image Capture where you can choose to download some images and pick and choose. Image Capture's Preferences will allow you to stop iPhoto opening when you plug your camera in.