>I've shot 6x6 Provia on a Mamiya 6 and had it scanned at 40MP and 80MP final output sizes; the latter was clearly better.

The real test is whether you can find any details visible in the 80MP scan that are lost if it's downsampled to 40MP.