What country are you in?
In general, you do need to still have a hot wire going from the wall switch to the ceiling fixture if you want to switch to be able to work even if your home automation system is off-line.
There are some safety code requirements that this be possible. In the UK, I think you have to do this with every primary switch, it’s only The accessories which can be done solely through network control.
In the US in most jurisdictions you are allowed to do this in many areas, but not all. It will also make your home much more difficult to resell in the future, just something to keep in mind. And not all building inspectors will approve it for a residential home even if technically it should be allowed by the code.
It also significantly limits your choice of equipment options. One of the most cost-effective ways to make a home smart is to use dumb lightbulbs and a smart switch. This works very well, but it does still require that there be a hot between the switch and the light fixture, because what you are automating is the switch turning on and off.
So I think the short answer is that well it is technically possible with today’s equipment, it’s not generally recommended. Instead, just use regular standard wiring to current NEC code (which will require a neutral at each switchbox) and that will give you the most options for the automation solutions which you will choose for yourself and what will be available to the home’s next purchaser.
You might have some specialty situations like outdoor garden lights where you wanted to do everything just through the network rather than with wiring, and that’s fine in most locations. But for just your regular residential lighting, I would go with standard wiring. It makes everything simpler as well as potentially saving you money in your home automation choices.