I don't think this is an appropriate topic for the iMac forums, but here goes anyway...
The built in iSight is not supported through Boot Camp. So the short answer to your question is no it will not work (as far as I know). I guess the good news is that a decent webcam that WILL work (from Logitech, MS, etc.) is quite cheap.
But yeah, that DOES stink that you have a webcam that doesn't work for you and that you will basically have a webcamp for each OS.