I see I have sparked a lively discussion here. Thanks so far for the input.
I definitely do not want a run-of-the-mill or mixed solution. I am fully aware that I have to invest something, but the entire system should last 20-30 years and run reliably. In addition, I want the security that someone can always help me without me having to throw everything away.
Furthermore, I want to network all systems and keep the option open to adjust or change something tomorrow, the day after tomorrow, or in 2 years. Light and music with fingerprint on stands symbolically for the whole story. When I am ready, I want to intelligently combine the shading with the underfloor heating, the photovoltaic system should interact with the heat pump and possibly also stop producing domestic hot water tonight due to the weather forecast since nice weather is predicted for tomorrow. In my opinion, the whole thing only becomes intelligent or "smart" when the systems are networked.
Regarding ETS: with the ETS demo (please correct me) I can only manage 5 devices, right? My system will certainly have more than 50 devices. How is this supposed to work then? I have no desire to spend another 1000€ and then have to hope that the programmer even hands over the project to me.
I already have some basic knowledge. To automate my system, I should not always have to get professional help (paying hour after hour)? With some sensors, I can already implement useful automation. In the end, the house should behave the way I want, not how it is described in a book.
I had a lot of time over the weekend to research. I still came across Loxone, which also works with KNX. But to what extent can I work on this myself, is there anyone here who has already worked with it?
At the same time, I came across a system I was not familiar with, "myGekko." Here, many different systems are networked, including KNX. As advertised on the website, no programming is done here, but everything is configured via one interface. And there are many other interfaces to Sonos, heat pumps, etc. Does anyone know this one as well?
Best regards Stefan