I'm eager to see Wildcat Lake and Panther Lake in action.
Nova Lake will mark the first time that Intel has tried multiple CPU chiplets for client desktop, looking a lot like AMD designs since Zen 2/3. For example, L3 cache will be split into two pools. Maybe you get 36-48 MiB in each one as the maximum available to a single core (Arrow Lake is 36 MiB), but the marketing department calls it 72-96 MiB.
Each compute tile will have up to 8P + 16E that we've grown accustomed to. Arrow Lake altered the Alder/Raptor design to intersperse the P- and E-cores for better latency when switching threads between them. There may be weird scheduling issues arising from a second tile, but it shouldn't be completely new to Intel since there have been Xeons with multiple tiles. These tiles being heterogeneous is a twist though. Then we'll apparently get 4 LPE-cores on the SoC tile. While there's deep skepticism about the benefits of lowering idle power consumption on desktop, you should be able to disable these, as others have already done in Meteor Lake.
For the leaked X3D competitors, they will only use one compute tile (all you need for gaming), but include the extra cache. Avoiding the complexity of 7950X3D/9950X3D or cost of a second cache chiplet is a good idea.