It would be fairly easy to make a house as you describe. It wouldn't be "aware" in the sense you mean though, but it is easy to put touch screens and microphones in every room and wire or wifi them back to a central house computer. A dedicated machine would mean there's no need for a tablet in every room and that would lower the costs involved. Heck, powerline-ethernet networking would even make wiring the house incredibly simple in practice as all the panels would already be wired for power, and that neatly sidesteps the issues of wifi security, wifi congestion, and signal issues.
Centralized programs already exist for controlling house appliances as well, one just needs the appliances. And with the rise of voice-command software for smartphones, much of the work has already been done there as well... put Siri or whatever on the house computer and create some extra software for Siri to interface and modify the existing software for the house systems and you'd be good to go. Siri can already handle many of the tasks like playing music or checking schedules or handling calls already honestly.
Chrispy, they canned Enterprise early because too many Star Trek fans didn't like it, with reasons ranging across the entire gamut. It's ratings weren't great to start with and they only went down as the seasons continued. The perpetual overarching world-ending story arcs the show revolved around certainly didn't do it any favors and eventually turned me off of it, I didn't even watch the final seasons.
I'd avoid power-line ethernet for this use. I'm thinking it would take GigE at a MINIMUM for multiple terminals to be in use simultaneously, with what usage I had in mind. Besides, powerline is damn noisy, and that;s the last thing you want in transmission media.
And by "aware", I was meaning that the house "knew" which occupants were in which room and what A/C temp they like it at, that the fridge was running low, showing what's consuming the most power in the house, etc...
Centralized servers like MS running HYPVER-V or VMWARE was going to be required, along with some SANS storage. I just don't know what kind of Open source equivalents for available, and how far they'd progressed.
This thing will never be FULLY like a Star Trek computer (they kept the main cores in their own smalll warp fields, to enable faster than light processing) (Gawd, it's sad I know that...), but I was trying to outdo all the "Houses of the Future" and "Smart Homes" out their.
The best I'd be able to do in real life, is have ONE computer for ever household member, have them all run VMWare, so I can easily restore the machine for when they inevitably break it, and TWO PCs for me, both with multiple biometric AND hyper complex passwords that NONE SHALL TOUCH BUT ME, lest they incur the nerdiest rant tantrum ever seen.