Yes, I fully agree personal experience is the best info'.
Smart CCTV might serve your purpose - there are several on Amazon, and from reading some of the customer reviews this one sounds close to, but not quite as sophisticated as, your requirements. It has a motion detector, but of course you require something a little more "intelligent", i.e. detection of whether the motion requires your intervention or not.
Amazon.co.uk User Recommendation