There's very little difference between the 7980xe, 9980xe, and 10980xe, so buy one of those, whichever is cheapest, overclock it as much as possible, and ride that until the next real Intel mainstream generation; Lga1700 is on its last legs, and the 14th generation is a stopgap.
I was in a similar position to you, rocking a 7940x that I bought for $290 CAD in 2021. I upgraded to a 14700k platform. While it is better for gaming, I don't notice a huge difference in productivity and everyday use. Kinda wish I'd kept my money for a while longer.
There's very little difference between the 7980xe, 9980xe, and 10980xe, so buy one of those, whichever is cheapest, overclock it as much as possible, and ride that until the next real Intel mainstream generation; Lga1700 is on its last legs, and the 14th generation is a stopgap.
I was in a similar position to you, rocking a 7940x that I bought for $290 CAD in 2021. I upgraded to a 14700k platform. While it is better for gaming, I don't notice a huge difference in productivity and everyday use. Kinda wish I'd kept my money for a while longer.