Still overkill, even with those needs.
If you were after a gaming rig right now, to last 10+ years, with everything set to ultra, I would be recommending to you a i5-13400. For 5 to 10 years a i5-12400.
Gaming is mostly quad core at the moment, a few will take advantage of 6, even less 8. The...