"X-No-Archive"
Depends what type of CCTV camera you are talking about. If you use a $30 CMOS bullet camera the web cam may look better! But depends what Webcam you are talking about also, and also the software you will be using. PC based Windows DVR software programs are generally much more feature rich than Linux or IP programs. Lux Riot is the only decent IP one Ive used worth talking about, for IP/NVR, etc. and ive tried them all while testing some capture cards.
Now if you are talking about a simple web cam like a logitech, etc, then yeah most CCTV cameras (CCD) will be 100% better, as they are designed for Video Surveillance. Panasonic makes some decent Ip cameras but looks like you are talking about USB so i imagine that means the cheap web cams?