Frequently updated resource link with some commentary on the various offerings of web cams.
Wikepedia article about UVC standards. This is the standard that most if not all new web cams and many USB devices are adopting as it allows for pretty much true cross-platform compatibility.
Here a few samples of UVC compliant Web Cams that should work natively with Tiger and Leopard:
- Logitech 9600 ( Top of line)
- Live Cam Optia Pro (Top of the line)
- Hercules Dualpix Chat Webcam (mid range)
- HP top of the line webcam. (Terribly ugly but reviews seem strong.)