Intel Xeon E-2278G or Intel Core i9-9900KF
Both have the same max frequency and the best single core performance.
But ... which is better?
Which will give stutterless performance and better performance when working with very large assemblies?
Which is more responsive when editing a dimension for example on a very large assembly?
What gives fastest refreshing on assembly with a lot of mates? What cpu attribute contributes to better performance when refreshing assembly with a lot of mates?
It depends on your daily work but I found through my comparative testing for day to day assembly opening, saving, closing, drawing saving, editing, loading that the greatest benefits were found with a higher single thread performance, so long as you have a decent amount of cores and threads to keep up.
A lot of operations are inherently single threaded operations in the same way that tying your shoe is a serial operation and tying the bow cannot be done asynchronously with the intial knot.
Heavy drawings really pounded that single thread and that is where most of the time in CAD is lost for me.
For me and Solidworks... 10900k all the way.
Core i9.
Xeon allow use of ECC RAM which is a bit slower.
As long as you're using Solidworks, all the "problems" you listed will be there no matter which CPU you pick.