MAXDOP Value of 0 compared to Value <=8
MAXDOP=0 enables SQL to use all available CPU's. - This is true upto 64 logical processors . If you have more like 128 MAXDOp=0 will still only use 64 logical processors.


For cores &lt; =8 you will still need to check on hyper threading enabled or not as that is also a factor that counts here.

Also for cores less than or equal to 8 on single numa , ideally is asked to keep as # of processors which is where confusion arises. Ideally in today's world its very rare to find such servers because if you are having issues on less than 8 core and looking to set MAxDOP you have a bigger problem.

But yes for less than 8 more or less will be same. But point to note is query process may or may not use all cores even when set to that MAXDOP. Also this setting should be checked in parallel with Cost threshold of parallelism as well