Creative web cams have some pretty good quality. I'll probably pick up a few. They also have some rather small ones..
I would get a creative and then another brand, so that they use different drivers, and you can use RRCam with both of them. Or maybe a capture card and a real camera, and then a usb webcam.
Right now, unless the cameras use different drivers, RRCam wont work with multiple cameras. I plan on fixing this in the future, however, it might be awhile..