I just plugged my Kodak DC260 into a USB socket and switched the camera into "connect" mode. A couple of seconds later the "Image Capture" app fired up automatically to let me download the photos.
Now that's slick.
Dunno if any other cameras are supported yet.
Mac OS X Hints
http://hints.macworld.com/article.php?story=20010328093523663