I think it could be a great value for a machine doing work (especially, eventually, the NPU) or possibly being an HTPC or other file server if there's no huge encoding going on. I suspect the Adreno GPU is much worse for desktop gaming than Apple's GPU cores, especially without the unified memory model. So it wouldn't be my desktop gaming box. (My current one runs Pop!OS, which is based on Ubuntu and handles Steam fine, and Epic Store okayyy under Lutris, but also doesn't force me to use Snap versions of stuff like Firefox, like mainline Ubuntu would. Ubuntu also didn't like the flatpak for Lutris.)
Also, without a CUDA translation layer I doubt people will be running LLMs and other ML stuff on it without a lot more work porting, and if there's not direct access to all that memory they probably won't bother. But it's nice if you do have a use for it. And if you have to, you could always put/leave Windows on it, I guess