As games become ever more multithreaded, Intel's hybrid CPU design might start to lag behind AMD's simpler but more effective architecture

Not necessarily. Ignore chiplets because that is mostly about yield and price and look at what happens when we go very threaded. Smaller cores with less clockspeed take up less space and less power and are more efficient with both which leads to more total compute performance in a given space and power budget. The ideal CPU in a highly multithreaded environment has a small number of P cores that matches the number of single threaded combining threads and as many E cores as possible due to Amadhl's law. The single threaded part comes to dominate given enough multithreading and all algorithms have some amount of single threaded accumulation of results.

AMD is working with the same limitations and bigger cores with more clockspeed will always have less total cores and achieve less total compute performance in that space. The single threaded component will dominate at high core counts so the answer is not all P cores and not all E cores and AMDs cores should be considered P cores. The ideal number of P cores is definitely more than 1 because the GPU requires one of those high performance threads and the game will need at least one depending on how many different sets of parallel tasks it is running.

But the problem is this theoretical future is a bit far off because we can clearly do today’s games with 6 cores quite happily and most don't really utilise 6 cores well. They tend to prefer all high performance cores, no one is yet at the stage of dealing with the added complexity of heterogenous CPU core performance and its why both AMD and Intel have special scheluders to improve game utilisation a bit better, this approach of differing core performance first a little and then with E cores quite a lot is too new since big AAA games are in development for many years. So while its likely the future gains from silicon slow further, necessitating optimising the compute density and balance of cores, its unclear when Intel's strategy will pay off in games, it pays off in some productivity applications but not games yet.

I am certain this approach and further iterations of it with multiple different levels and even instruction sets are quite likely the future of computing, so far its been critical for the GPUs success, its really unclear when that likely future will happen. It definitely doesn't make sense now or the near future so buying a current Intel CPU for games makes no sense.