Any camera that is supported by video4linux (v4l) works. Look here:
I know firewire *webcams* work fine. However, a camcorder uses a different firewire protocol, it's not a webcam protocol, it's another one. I've seen it be done, so I know it's doable, but I don't personally know how complicated it was to get it working.
Does that help a bit?