Idk about if these hit your use cases but I’m building a house right now and here are the things I’m incorporating that are actually useful for me:

1. Speakers and microphones in the ceiling to use with a local smart assistant that uses chatgpt or whatever the most capable model currently is (basically a much smarter version of siri you can ask most any question and can control home stuff with)
2. An automated dog door with locking feature. Currently on weekends my wife or I alternate days of who gets to sleep in and who has to let the dogs out. In the new house we will have the dog door open at a certain time in the morning unless it has rained over the night in which case it will send us a notification to take them out manually
3. Smart blinds in front of the window in our bedroom. They will slowly open up from being fully dark to fully open over a period of like 30 minutes based on an alarm time allowing us to wake up to what will feel like a natural sunset at any time of day we wish to wake up