Brinno Time Lapse Camera
The Brinno time-lapse camera create cool videos with the push of a button. The camera does all the work for you. The camera is also weather resistant and even comes with a macro setting. The best part is that after the video is done, it's actually a video, not a series of jpgs that need to be stitched together.
SenseCam from Microsoft
Not entirely conceived to create cool projects, the SenseCam from Microsoft is more like a tool for dementia patients. It's wearable and takes a snap shot automatically without any user intervention. A wide angle lens maximize the field of view. Comes with a light-intensity and light color sensors, a passive infra-red and even an accelerometer. The sensors help the camera to automatically trigger a photograph to be taken. It can also take pictures at a pre determined time interval.
PlantCam Digital Garden Camera
The PlantCam will take 4 megapixels stills that are great to monitor growth cycle of your own herb garden. You can select from low, medium and high resolution images with great clarity. It's weather proof and the photos can be converted into video, so you can watch the clip instead of a gazillion of photographs. 1 month can be watched in 30 seconds.
And for the DIY prone, here is a system that you can create using a cheap point a shoot camera and some electronic components.