To work around memory issues, these CPUs would need some onboard memory which would increase costs a bit, but the tradeoff is that it’d make for simpler, cheaper low-end motherboards. One can imagine a mini-ITX board with nothing but a CPU socket and a couple of M.2 slots that’d cost significantly less than current entry-level ITX boards. A full system upgrade could be performed by simply swapping out the CPU which would be great for non-enthusiasts; without a power hungry discrete GPU, power requirements are unlikely to increase meaningfully (and in fact are likely to decrease with upgrades), so upgrading wouldn’t necessitate a PSU change. These hypothetical boxes could easily stay relevant for a decade or more.
Higher end SKUs of motherboards for this type of CPU could have the usual RAM slots (acting as a second tier of slower RAM in place of swap), PCI slots, etc.