Rule Machine is most useful when you imagine it as building blocks (Lego's).
You'll want to understand everything it takes to do each of your pieces. What does it take to Turn on your Wyse cameras with the options you describe. What does it take to shut the main water valve? Ecobee is an identifiable product, so the steps needed to put it into Away is mode is clearer.
SMS.. It's clear you're using this as an Intruder Alert and Hubitat has a limit of 10 SMS per day! With 2 being consumed on each motion alert, your intruders will burn through to your limit in just a few steps. Then it will seem as if they left
Perhaps you'd rather use Pushover, which sends Notifications vs SMS to your phone. You get 7500 notifications a month, free.
Because your question is product agnostic, you may need a Rule per. One Rule to manage your cameras, one rule to shutoff your water, 3rd rule for ecobee, etc. Rule quantity is not an issue, you can have thousands if need be. And then you can interconnect them with yet another Rule.
The point is, you can build this up as a set of Rules vs one and then optimize as experience dictates.
I'm sorry my answer is generic, but I hope you see that the answer is probably: Yes, you can do it.
It gets easier with HE. The Hubitat team and the community can help you out with just about anything. You won't be sorry you made the jump to HE.
With your Wyze cam, you'll need to set the cameras in your app to always monitor motion and other things, but you'll probably want to turn off notifications. This way it will always trigger your IFTTT rule which can push it to Hubitat. You can mess around with turning on and off the motion through IFTTT but I found that there is a higher error rate as it is a cloud to cloud service and one time I left it didn't arm the camera so I would not have received any alarms. Better to have it always armed and miss one motion event than get none. Odds are if someone broke into your house they would trip the motion more than once anyways.
Turning them on through the app would be a good way to go while keeping Big Brother out. Mine are pointed at doors with the microphones always off. I just hate pulling out my phone to control anything, I try to automate it. One thing I did notice is that the cameras seem to be prone to false motion detection's when lights are turned on when it is dark out. Still trying to figure out a way to minimize that; still not bad for the price of the camera.
RE Wyze. I have 32 gb cards in mine, always recording, but not notifying (just in case). Also using a virtual switch with IFTTT and Chucks driver using webhooks rather than the applet looking for on/off activity. I’ve found this method way more reliable. Driver, here. . Just past in the webhook URL for on and off.
Having the recording saved both our cats going to the vets, wed never know which one was ill (I’ll spare the details lol). Now we do, halved our bill.
Using the always recording, at least you can view this and save to your mobile device if needed. I also suffer the lighting sending false alerts,