http://micasaverde.com/vera-lite.php
The Vera Lite is probably what you want... It can handle your existing sensors and do video (although the video isn't anything spectacular - I use a different system for that, but it does work).
The Vera has "app" concept - so from the controller you can install MiCasaVerde or community provided applications to do certain things (i.e something like a countdown timer for a scene, or an app to control an OTS yard watering system for example). But the best part is you can write your own apps (LUA). The system is entirely hackable (SSH access). So it's basically an open slate to most extent. But, the key thing is there's no monthly fee if you want to use their cloud service - you just need an account and controller (I'm guessing they collect stats on you events - but that's just a guess on my part).
The UI leaves something to be desired - and again, that's where startups like SmartThings will capitalize (pretty).
IP cams (especially the ultra cheap ones with pan and tilt) are way up on our list. It will be one of the first client modules off the shelf in the new year.
edit- It does not support the sensors :(
Also, will it work with standard security/video cameras (RTSP/RTMP)?
edit- no, it does not look like that works now either :/