No matter what RH is going to ignore or be unable to detect the camera. DigiCams are much more of peripheral item whereas RH's hardware detection is more built towards identifying the guts of the machine.
Offhand I recommend Kodaks; which seem to be supported to Pluto and back under Linux, and which a few friends of mine have had success with. I, however, still have to dual-boot into windows to get photos off of my Vivitar. My guess is that this is to deal with a portable camera that does stills and not a web-cam? If I'm wrong, and you're trying to get an always on webcam, starting up its Hardware recognition and services would be a matter of an add-on to RH and not something RH is likely to do for you. You might have a bit of a problem with the age of the distro, as a lot of these camera progs are built to only work hapilly with 2.4.x kernels, but a newer distro would probably run like sludge on a 486, unless you want to go with one of the slimmer ones like Slack or Deb. Its kind of a catch-22, but it can be sorted.