I think my thread is still on the first page of the "input devices" titled something about pc's, cameras, and integration. It defines pros and cons of some methods of recording and has a couple camera links in there as well.
If you want a discussion on different cameras, someone else might need to chime in (soundman, don't you work with cameras a lot and have that knowledge?).
If you want a general guideline for hooking up the cameras, a little insight of how you might want it would help. Do you care about quality? cpu hit? webcam? composite? lots of options, but we're here to help!