If CAMM2 becomes standardized for Desktop air cooled CPU heatsinks are going to become massive. We'll possibly even see a motherboard redesign. Moving the ram location from the top right to bottom right so the CPU socket location can be centered more. As a result we'll likely see quad fan sized CPU heatsinks.
It'll be interesting for sure, especially for really clean looks. Not seeing a major use case and much appeal out outside of a very select subset of DIY builders (like 1% of the market). The major test would be AIOs and mini-PCs (which is contingent on someone making a popular one), and that would be 2026 at the earliest.