Hi,
I got myself a Watchbot camera via Groupon.. and I must say.. for 49 euro you get a lot of camera.. it can pan/tilt (not zoom!).. has an integrated motion detection and you can quite easily script it from linux.. (so you can have it move to certain positions or in my case have it shoot a panorama).
The logfile for the motion detector can be read using wget and integrated into your website (as I did on Icepick.com ).
The video quality is quite good.. it comes with IR lights and at night it still gives quite a nice b/w image.. at daytime it switches to color... the only downside is the resolution is 640x480 and when it's between night and day it sometimes gives strange color because of the bright IR lights (but once its light outside this problem dissapears).
Hope it helps!