The NUCs are looking pretty good as well, especially the latest ones. For most tasks, they have enough GPU power for home use, and with a NVMe/M.2 SSD, I/O is less of a bottleneck. Eventually, I may buy one just for a virtualization server.
PCs are just too versatile to be "dead". Take a desktop that is too slow for day to day stuff, toss another OS on it, and it can do other tasks, offloading stuff from the desktop. There becomes a point where it becomes a waste of power, but an average PC bought now has at least a ten year lifespan before it is not worth running even as a background server.