iPhoto will work with almost all cameras, it may not "officially" support it, but it will work. In iPhoto, a supported camera will have it's name and a pic of the camera in the bottom left corner, but on a non-supported camera, it has a generic pic of a digital camera and just says "digital camera"
My office has an old CD mavica that i connect via USB, and it works fine, except when the camera shorts out ( i hate that camera) i also deal with a lot of digital cameras at work and iPhoto works everytime. Don't worry, just buy a camerait will work.