hAP be³ Media (MA53UG+HbeH)

If you wait a bit and are ready to learn a bit about networking then mikrotik releases a hap be3 very soon. You can run homeassistant and pi hole in there as containers and it has threads network also. And wifi 7. And would work for media sharing. But it takes time to set up and learn about. What you mean no ethernet? Do you have fibre or will have 5g or something like that?

I would recommend you Mikrotik. You get all features of professional routers but at reasonable price. I have hap ax3 in my apartment and works great. If you can wait a little, get a hap be3, it is already in shops but not available for order. Mikrotik is great but can be a little bit harder than consumer routers, but they have great tutorials and if you don't want to learn much you can use quicksetup. RouterOS supports containers, so you can run HomeAssistant, PiHole, file sharing etc.

NGL I think it’s smarter to buy older gen wifi or used with one of the managed solutions, rather than bleeding edge unmanaged wifi 7 Potentially OP if interested in one node might dig in and research Mikrotik hAP very closely to see if it can do the needful WiFi VLAN. They’re not known though for strong wifi. My hAP is only used as a firewall as a Temu UDM , with the WiFi as an emergency fallback during a power outage, when I don’t power my APs

Do you have any references comparing firewalla to UniFi, Mikrotik, and PFsense/other x86 software firewall? I got some “upgrade to 1/10Gb fiber ads and am tempted”. Currently at 0.6/0.6, which my hAP can do no problem

Yeah, it is but bang for buck Mikrotik can't be beat. From home gear to their cloud core gear, unbelievable value for money.