I won't accuse you of thinking too much. Not sure I'd want a siren kicking off, maybe flash a couple lights or make a Hue light flash a couple different colors.
This would be beyond the scope of a Ruleset imho. But pretty easy to do watching the log files and writing a script.
Really I would think you would be watching at the appliance level for most of it, water pump, heater, ac can be monitored at the breaker or inline. But yes, you can monitor whole house, develop a profile and action when there is an exception to the profile.