I've searched about for mentions of using webcams for CCTV and it all gets bogged down with IP streaming and the like. I want to go back to basics:
Webcam (or the new on-board camera when it appears) plugged into the RPi. Video is sent directly to the Composite Video output (full screen) to your front room TV.
"Err... why do this, just buy a basic CCTV camera, they're all Composite Video!? Sheesh... why do we have to let the noobs on here!"
Aha! But your £30 crappy CCTV camera doesn't have a text overlay and even the ones that cost a bit more usually just have text for the camera name and maybe the date and time.
If we have a Cam + RPi we also have all the cleverness of Linux/Python/etc. at our fingertips. I'm thinking once Cam > RPi > TV is working I could add in some sort of text and/or graphic overlay to it...
Imagine you had a weather station running from your RPi (some people are already doing this) and the info (wind speed, temperature, high/low points etc.) was overlayed on the Webcam of your garden. BAM!!!! your own personal weather channel right in your front room. So simple, even the wife could understand it
So really we've got Webcam > RPi > (insert amazing info text overlay) > TV > uberkewl!!!
Now... how we gonna do this?