To me, Home Automation is a lot like deciding on which cordless tools you want to buy because for the most part your buying into a 'platform' and you need to see what is available on that platform...
I got started out years ago using X10 and then migrated to Z-Wave which I have been very pleased with. My first Z wave device was about 15 years ago, we have a recirculator pump on our water heater and we didn't want it run all the time so a simple Z Wave appliance device allowed us to turn it on and off by some simple hand held remotes we kept in the bathrooms and kitchen
Now I have about 60 different devices that control lights, whole house fans, door locks, my air compressor - I even have a Z Wave 'zapper' type mouse trap that I stick up in the attic. When it kills a mouse, it sends me an email. Z wave with decent automation software can do a lot of things.
Examples, we usually run our whole house fans at night, but I have a Z wave event that will check the outside temperature and if it is above a certain setting, it will shut the fans off. Now if we want hot water before taking a shower or washing the dishes, we just say 'Alexa, Hot Water On' and the recirculator pump will start and automatically shut off 5 minutes later. I have a water shut off valve on our main water line and several leak detectors throughout the house (kitchen sink, washer/dryer, water heater, etc) A couple of months ago our garbage disposal started dripping water through the bottom and needed to be replaced. The sensor tripped, shut off the main water line and sent me an email. The sensor caught it before any damage was done. Lastly I have some Z-Wave, Decora Style switches. They can actually detect how many times you press the 'on' or 'off' paddle and that can be used to trigger other devices. Press the kitchen light switch ON 3 times, and it turns on other lights, or control any other of my Z Wave devices
Personally, I would avoid a proprietary system like Ring or something that uses WIFI. Z-Wave is an open standard and a Z-Wave device should work with almost any Z-Wave type software. Each 'hardwired' Z-wave device works as a repeater, the more devices you have the better the system works.
And yes, it is rabbit hole