I have recently moved to the Intel NUC7PJYH J5005 NUC. Quad Core Pentium, WiFi and Bluetooth built in, SFF, x4 USB and SD card reader. The CPU has a TDP of 10w and performance of old legendary Q6600.
Covers almost all that you need, and is very cost effective for what it can do. I picked up an brand new one, 8gb 2133mHz RAM, and a 120gb SSD for $400 AUD.
Installed Ubuntu (officially supported on this model), and run HA, Motioneye, Unifi, MQTT and Syncthing all in a Docker stack. Doesn’t skip a beat and is very quick for reboots, etc.
I see what you’re writing, but moving the stuff to external devices was never intended. So the requirements are still there. The questions rather boils down to how far can you go without external devices. Obviously some of the dedicated providers for Gateways have this in their specifications. So there should be possibilities.
You want integrated zwave and zigbee radios? The closest thing I can think of are purpose-built devices, designed to run the manufacturer’s home automation software and nothing else (SmartThings SmartHub, Vera VeraPlus, Wink, etc). You’re not likely to find that in a PC architecture nor in any of the popular single-board computers.
You’re welcome to look for this holy grail but consider this: Home Assistant and openHAB have been around for years and comprise thousands of loyal users. If your “ultimate” machine was available, it would already be in use and mentioned in both forums. FWIW, I’ve been reading both forums for several months and haven’t seen a thread about such a device. Nevertheless, feel free to search for this magical beast and please do let us know if you find it. Good luck!
The device you are looking for does not exist. The whole idea witj HA is to have a software that can handle many different platforms. I have the features you want using external devices. The 4G is handled by a failover 4Gdongle for the router. Stop looking for your dream device, its total waste of time
I don’t think it’s a waste of time. Devices are improved all the time. If you take the hardware from a normal Vera Secure or a Homey, you’re not far away. It’s just a matter of how much is integrated and what at the moment can only be achieved with externals. Maybe 100% can’t be achieved at the moment, but quite a bit can be done already and keeping the amount of devices reduced can be seen as progress.