Should I wait for the next release of Intel CPU which is suppose to have more cores ?
Because I really want to Vision G board but it is out of stock or to expensive right now.
Yes, I want a motherboard loaded with the latest technology.
by budget I mean under $300
Not my understanding of "budget", but that works out well for you…
Forget about "latest technology". Apple is dropping Intel CPUs. The last fully supported combination is 10th generation on 400-series, which is already the
previous generation. Buy what you can find now, 10th gen. or older.
If Thunderbolt is also a requirement, beware that it takes 4 PCIe lanes—and the Vision D has to take them
from somewhere, it cannot be a Vision G with one more feature but nothing
less.
500-series has no iGPU support whatsoever, even with 10th gen. CPU (that may seem of little relevance for you, but a GT7xx is really no better than an UHD 630 iGPU, so if you're also looking for a dGPU you have to factor it in your costs or go iGPU after all). Hackintoshing on 500-series is also less polished and has less support than 400-series.
Do not even think about next generation Alder Lake. "No iGPU" is already baked in. It may not work at all due to the hybrid architecture. If it does, scheduling will be sub-optimal. And then, there's the instruction set…
Intel has added AVX and AVX2 to the Gracemont efficiency core but dropped AVX-512 from the desktop Golden Cove cores (only Sapphire Rapids Xeons will get Golden Cove with AVX-512). The last supported Core CPUs had AVX-512. The iGPU-less SMBIOSes iMacPro1,1 and MacPro7,1 have AVX-512. This means that, if Alder Lake can be made to work, probably with id-spoofing and kernel patches (and that's a significant "if"), it will run into the same issues as Ryzen and suffer the same limitations as Ryzen: AVX-aware applications (of relevance to you, I guess) will crash when calling their AVX-512 code.
I see little point in having the latest and greatest Intel CPU to browse the web and run office applications but not (or with limitations) Photoshop, Lightroom, DaVinci Resolve, etc.