Actually any of the the new Logitech web cams do really well. I had an old one that wasn't very good, but my brother got me a QuickCam Communicate that has the newer optical sensor for Christmas a few years ago and the picture is really good and it does really well in low light.
Communicate Deluxe
Communicate MP/STX
If you're wanting a really good web cam they now have "HD" ones. There are three in the series right now, and two are just at the $100 mark.
Logitech "HD" Webcams
Depending on how much your using it the Communicate should do the job quite well and the price is actually decent.
