How about on your iPhone or Blackberry? May be tough - and expensive. Video in general is a lot more common, with not doing what you describe. Today's smart cameras for the home are wireless and allow live viewing any time, plus have motion analytics built into them, so that the camera only records (usually a clip, like 15 seconds) when activated by motion. You really don't care if nothing is going on, right? The clips can be sent directly to you. These cameras can also be viewed remotely from any web-enabled device - and what's even better, the video clips can be stored remotely by your service provider, where you can access them.
What I am describing is actually the video service that we include with our cellular and interactive monitoring services: next-gen features, integrated with home security.
You would be amazed how reasonable these systems are, especially in light of what they can do. This may not be exactly what you were looking for, but regardless, it's good to know what's out there, and the direction the industry is taking.
With over 20 years in the alarm industry, I work for FrontPoint Security (http://frontpointsecurity.com), a leading nationwide wireless home security provider. Our company offers cellular monitoring and next generation features the “big boy” traditional companies have not figured out yet. I am offering this advice to increase awareness of what alarm systems can (and should!) do. The more we all know, the better!