One way to assess processor capabilities is to look at the passmark ratings.
If you now have a I9-10980XE processor, it will have 36 processing threads.
If all 36 are fully busy, the passmark rating is 33344.
But, to manage many threads, there will be a master thread that needs to be fast in single thread processing. The single thread rating is 2672.
https://www.cpubenchmark.net/cpu.php?cpu=Intel+Core+i9-10980XE+@+3.00GHz&id=3630
The theoretical underpinnings are explained in "amdahl's law"
https://en.wikipedia.org/wiki/Amdahl's_law
The I9-12900KS is a well binned version of the I9-12900K.
It has 24 processing threads(8 of which are slower efficiency threads)
and a rating of 44499. The single thread rating is 4381.
https://www.cpubenchmark.net/cpu.php?cpu=Intel+Core+i9-12900KS&id=48
Is such a processor worth it to you?
Only YOU can decide.
Such a change would also include a new motherboard and possibly ram.
This fall the 13th gen raptor lake processor is due to launch.
The top end will include more processing threads and likely a modest boost in single thread capability.