I just wanted to quickly address a few points that got a bit lost in the ERR discussion. Ultimately, with such a "hobby," a lot is also a matter of taste, but from my perspective, there are many things that are a lot of fun/make a lot of sense and things that are not much fun for what they cost.
(1) Starting with very simple functions like automatic light on/off with presence detection for 6 rooms (WC, utility room, storage room, hallway upstairs and downstairs, staircase)
Why only six rooms? We have it in every room, and that is also among the things I wouldn’t do differently. Costs are low if you consistently omit switches, and the benefit is really high.
Especially hallways, kitchen, bedroom, dressing room, bathroom make a lot of sense in our daily life. It doesn’t work perfectly in the offices, but there are switches there as well.
(3) In the entire upper floor (6 rooms) a night light should come on at night upon movement (going to the toilet)
Most PMs can do that directly. Basically, it is important to plan lights everywhere at the right places.
(4) All blinds (16x) should be individually controllable (based on time or sun position)
Are you sure they will be blinds? Before I invest 50k in a smart home, I would definitely upgrade from blinds to venetian blinds! The comfort gain is much greater.
And with venetian blinds, you can nicely do slat adjustment based on sun position, temperature, etc. One of the best features in a smart home.
(5) All windows/doors (17x) with tilt sensors to detect open windows, e.g., warning in case of rain, warning when leaving the house, simple alarm system
Also think carefully again about which states you want. We have closed, tilted, and open based on the handle position.
That’s quite nice, but also quite expensive. For most things, a simple sensor would have sufficed. We only use the tilted state to put the venetian blinds into a "ventilation position."
(6) Front door with electric lock and video doorbell
Lock is also quite expensive; an opener is often enough. I find a video doorbell unnecessary and expensive for a single-family house, but that’s certainly also a matter of taste.
(7) Underfloor heating digitally controllable per room
As I have explained extensively, a very clear yes! It costs very little and enables much more flexible use, setting, and monitoring.
(8) Simple automations outdoors for lights (motion sensors) as well as cameras
With KNX outdoors, I am always a bit skeptical (KNX secure not yet advanced enough) and have kept it minimal in our system. For cameras, plan exactly where they should go and prepare the network accordingly. I then had to work with surface-mounted boxes to get the network cables in. Maybe that could be improved. ;-)
(9) We want to avoid switches wherever possible; we prefer voice control or ideally no interaction at all (automated)
Very good. Saves money, looks good, and is truly smart. But it really requires good planning.
(1) Hot water + circulation only at certain times or when someone is home (is it even financially worthwhile with efficient heat pumps?)
Yes, it is worth it. Otherwise, the water cools down fairly quickly.
(2) CO2 sensors, for example in the study, to control ventilation based on presence/absence (ventilation e.g. at max when I briefly go get coffee and the CO2 value is above X?)
We have them in some places. CO2 sensors are really very expensive. Therefore, I would just install a single one in the exhaust of the centralized controlled residential ventilation afterward and regulate with it.
(3) Networked fire alarms as an alarm system + to hear a fire alarm from the ground floor in the bedroom (?)
I have that; it was also rather expensive and especially a pain to wire. I probably wouldn’t do it again. ;-)
(4) Vacuum robot in the hallway that automatically starts when the house is entered or left (dirt in the hallway)
I implemented that with Valetudo. But it's actually independent of the smart home.
(5) Lawn mower that only runs in certain weather + when no one is in the garden
Robonect planned. But also independent.
(6) Automatic garden irrigation depending on predicted weather (cistern planned)
Also independent.
(7) Towel heater in the bathroom to switch on/off as needed (e.g., warm bathroom in the morning, warm towels right after showering)
Currently more or less the only application for switchable sockets in our house.
Much depends on the budget and possible DIY efforts. You really have to be careful not to add too much on top. Therefore, clearly prioritize what really makes sense and is fun!