If you really need it, you need it. I was stuck for the longest time in the same boat and only got around it by separating my systems by use case, not one system to do everything. Sapphire Rapids (W-2400/W-3400) was somewhat tempting since you will get full AVX-512 and a more monolithic-like experience than any AMD does. If you're not limited by the poor internal bandwidth on AMD they do scale for more cores, but personally I wouldn't go older than Zen 4, again for AVX-512. Zen 5 version will be great but who knows when they get around to launching it. I'd rule out Zen 2/Zen 3 on that basis alone, but that's just for my us