Thank you so much for your very detailed answer!
The problem I have is both lights use multiple G9 bulbs. I've tested with smart bulbs but as I need 6 bulbs in each room, its very expensive. And as you mentioned, there is also the problem of needed to use an app or voice to turn them on and...
I'm in the UK. Also, please excuse my terminology as I'm very much a beginner.
This plate has 2 switches. One switch controls the the light in the room that the switch is in, the other controls a light in the adjacent room. The pictures are not very clear but the connectors are as follows...