That things still considered top tier. Only possible issues are with GPU's that need the new 12 pin connector, but they all come with the GPU.
I'd buy a quality cable sold by Corsair for that exact PSU, to avoid the adaptor.
Anything out there from either camp exceeds the performance you had on that setup back in the day. Quickest summary would be:
1: CPU's single threaded performance controls your "lows" - the performance your system drops to.
Go to TPU's latest CPU review, find the 0.1% lows and you get an idea where its smart to run your framerates at.
These values don't change with graphics settings or resolution. The reason the 4K results are lower, is the RTX4090 is the limiting factor here.
View attachment 326573
Just to reiterate my point, these are the bottoms of those graphs. All of them are GPU limited at ultra settings on 4K even with a 4090.
View attachment 326574
Intel Core i9-14900K Review - Reaching for the Performance Crown - Minimum FPS / RTX 4090 | TechPowerUp
2. Buy a monitor with a refresh rate lower than your CPUs 0.1% lows.
Use Freesync or Gsync if you don't want stutter or tearing.
Use an FPS cap, either 2FPS under your refresh rate or at exactly half your refresh rate. No micro stutter, no tearing.
Only the extremely expensive top of the line Gsync ultimate displays avoid this issue, it's always been there it's just more obvious with faster CPUs.
3. Buy a GPU that can handle your chosen refresh rate and resolution, lower settings in games it can't keep up. FSR and DLSS help massively with this and are NOT used in the above graphs where the 4090 is the limit.