New to home automation -- How limited am I by old wiring?

There are lots of solutions for that particular issue, including smart switch covers (but not the one I already linked to, the kind that don’t change the switch underneath)
.