The mimimum is a 6 core cpu with 12 threads.
Again, I need an
official source from the manufacturer themselves. Tom's Hardware does not count, this is just their assessment on what they think is needed to run games at a certain performance level.
Because I can most certainly go into my BIOS right now, disable 2 cores off my 5600X, and everything will still run. And I would argue outside of some recent games that I have in my library, they'll more than likely run at roughly the same performance. Also, core count means little with regards to the CPU's actual performance. An i3 from today will handily outperform an i7 from more than 8 years ago.
4770k will be a massive bottleneck
This depends on what settings you're using. If you're using 1080p, sure. If you're using 8K, definitely not. If you want to ask me how would I know that, I don't. But I can look at the 4K benchmarks, see that most of them float around 140 FPS, know that 8K renders 4 times the pixels as 4K, which would require around 3-4 times more work. That would drop the frame rate to below 60FPS
That is well within the range of what the i7-4770K is capable of pushing.
and wont be able to run windows 11 and thus the most modern games.
Uh, there's no game I'm aware of at the moment that
only runs on Windows 11. You're free to point one out though.
DDR3 is below minimum spec for most games.
RAM type has little to do with overall performance. And "specifications" for games doesn't really mean anything with regards to performance. It's just what the developer is willing to support if you have a problem. I've done tests where the game complains up front that my hardware won't work, but it'll still play and run it just fine.