I recently finished renovating my 20 year-old resale flat. Bought it last year from the original owners. So it's a total rip out and redo situation. So of course, it' the perfect chance to implement home automation.
My biggest piece of advise to anyone who has the opportunity to renovate is, ensure all your light switch points have neutral wires. This way, you have many choices for light switches. Automating lighting to me makes the biggest impact on convenience, so it's rather important. If you don't install neutral wires, then you're pretty much limited to using much more expensive ecosystems like Hue.
Decide now which ecosystem you want to install. Z Wave? Zigbee? Then you can research what switches are available for each ecosystem and find out the requirements for the switch size and more depth. This will affect what your electrician needs to do to accommodate them (might be a lot of digging bigger/deeper holes on your walls to fit dimming modules..etc).
I use Fibaro, and I chose to use dimming/switching modules that are installed behind regular switches. Why I chose to use modules over all-in-one switches is, the switches still work manually even if the modules fail. Downside is, dimming modules require single-gang switches, and on/off switches require double-gang (nothing more) switches. So my whole house has many single-gang and a few double-gang light switches. For example:
So, all in all, extensive planning is required. But the basic requirement for anything you want to automate remains the same. Lighting, curtain motors and door motors require neutral wires at their switch positions. Do this, and you are covered for anything you want to do, whether it's now or in the future. On/off electric switches are far easier as you can simply buy wifi switches that don't require anything different.