Yeah the celeron and pentium models are amazing low power machines to run Home Assistant on. Mine is running half a dozen other docker addons including frigate to do ai object detection (offloading most of the heavy lifting to a Google coral chip plugged into usb)
Being the default industry standard meant drivers were never a hassle
There’s a few boards that bridge the gap between pi and a pc for media servers and small NAS uses. Look at Asus Tinker board, Odroid, Udoo Bolt, Orange Pi, Rockpro64, BeagleBone