My favorite camera these days is my Nikon AW130. DSLRs stay at home in the case while I'm playing with this. It has some built in timelapse functions that are just plain fun.
Titles added later, but the video is just with the sun setting. Point and shoot, on a tripod, the camera does the rest...