i9 = overkill
Even the i7 is kind of overkill for most people, the i7 12700 is within a few FPS. Even the i5-12600 is not far away. Games dont relay use many cores, it's just down to speed. I suspect a OC will almost equalise all the intel stack in 90% of games. If you're not doing any creative work or multithreaded work, the i9 definitely is overkill for you. If you're looking to edit videos etc. it might have some value, but even then the i7 12700k is more than enough to handle most video editing purposes.
If you're just looking for price to performance for gaming, you might want to look at AMD. The 5800X3D is still the best value high end CPU there is for gaming. It even outperforms some of the 13th gen Intel CPUs, according to Intel themselves. The only problem with AMD is that Ryzen 5000 was their last generation of zen 3, meaning you wouldn't be able to upgrade much further in the future without having to swap at least your motherboard and RAM with it.