This really depends on the film and MF lens. 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. Resolution can be even higher with modern fine-grained black and white film.
> You still want to shoot handheld, so you want a really fast lens to minimise the impact of camera shake.
Or image stabilization, which also adds weight and size.