A cam that works with distro "abc" should work with distro 'xyz' just as well, though some distros might have more webcam drivers enabled/built-in than other distros
out-of-the-box. The important part is what chip(s) are inside the camera, rather than the name on the outside.
A good place to start deciding, would be the LQ HCL:
http://www.linuxquestions.org/hcl/
Another good place(s) to research is this list of links here:
http://www.linux-drivers.org/usb_webcams.html
And finally, a really great resource to see the Linux status of various cams/drivers (this site is
very helpful in determining what driver a given camera should use, and how well it works):
http://mxhaard.free.fr/spca5xx.html
Best of success - I hope this can help you start to decide!