What I'd like to do is to add some CCTV cameras, but use a PC to
capture the pictures and software to trigger any alarms.

You could have bought USB based cameras. The camera sensor will be the same
CCD, but the signals are kept in a computer friendly fashion rather than
converted to an analogue signal that the computer requires expensive
hardware to understand.

Christian.