>No one seems to have a decent plan for how to balance local memory resources with cache-coherency over CXL

I have seen a patent application for a technology from {big hardware company} addressing exactly this. Dunno if the approach will work, but there are definitely plans