As mentioned before, gphoto is the standard app for transferring picks from
digital cameras. Check the program or their website for the list. (
http://www.gphoto.net/cameras.html )

I have a Kodak DC210+. I recently got tired of transferring via serial cable
and picked up a Sandisk ImageMate SDDR-31. Works great with the usb-storage
driver. Make sure you don't get any other Sandisk USB drives though, that is
the only one that works under Linux. (
http://www.sandisk.com/tech/im_faq.asp ) On the bright side, at $30 the
reader is the cheapest CF reader I saw. (actually, reader/writer) The thing
doesn't feel cheap either. It feels solid, well made. 

Stick with cameras that use CF. Some Olympus cameras user their Smart Media
that generally uses a floppy and some whacked windows drivers to transfer
photos. Not exactly Linux friendly. Never been impressed with the Sony
cameras that use floppy drives, but if Sony was smart Memory Stick readers
should work with the USB storage drivers. Sony does some neat stuff with
Memory Sticks (like a combination mouse and reader) but only Sony has
embraced the technology.

My opinion is stick with camaras that use Compact Flash. At least then you
know you can get to your pictures one way or another under Linux.

--
Andy Zbikowski, Sys Admin   | (WEB) http://www.ltiflex.com
LTI Flexible Products, Inc. | (PH)  763-428-9119 (EX) 132
21801 Industrial Blvd       | (FX)  763-428-9126
Rogers, MN  55374           | (PCS) 612-306-6055