The Raspberry Pi Camera is a great tool; it allows projects that require a camera to be put together quickly and on a budget. Plus, having a Linux back end for a little processing never hurt anybody.
An off-the-shelf kit and about two hours are all you need.
If there's one thing that homeowners should consider, it's security cameras. They're great not only for deterring would-be robbers from breaking into your home but also for checking in on your pets ...