As far as I know as long as the camera supports DirectShow then there shouldn't be a problem. Which probably includes every camera on the market with windows drivers. It would probably work with Firewire cameras as they can appear as directshow sources as well.

EDIT: We used it with a webcam that cost £10 brand new. I doubt you'll have problem with whatever you choose.