If you are upgrading your cpu to a modern intel 9th gen or ryzen 3000 series processor, you not only need to upgrade your motherboard, but you will also need to change to ddr4 ram.
I happen to like the intel 9600K processor. You will also want a Z390 based motherboard.
But many on these forums prefer ryzen for the cheap threads.
If your purpose is gaming, I tend to favor intel.
If your purpose is batch production, favor ryzen.
But, truthfully, any current gen processor in the $200 range paired with a $400 graphics card is going to game very well.