A few random thoughts:
What makes an image great/valuable/interesting/compelling/memorable, or whatever other merit it is imbued with, is only sometimes related to it's resolution. And there are many reasons why one might want to shoot medium format film unrelated to resolution. Resolving more detail, compared to a modern medium format camera, is not really a reason to shoot medium format film.
Drum scanners legendary status is largely a case of being compared to the only alternative of their era (flat bed scanners). Drum scanners were a decade ahead of their time when they were in their prime, but are now far from state of the art. The
best performing film scanner now available are actually with a phase one digital back, and is being used at Library of Congress, Center for Creative Photography (which houses Ansel Adams and Edward Weston's work), the Getty, and many other top-end institutions.
Tests run of film resolution in studio test environments bare little relationship to what can be expected in the field (ditto with digital, though with an intrinsically smaller disparity). Once you add in the issues of ground glass focusing, mirror slap, wind, film flatness, and the inability to fine-tune in the field based on 100% feedback the typical results are, even in the hands of a master, rarely anywhere near the studio test. In practice, the overwhelming amount of field film work would have been
easily out resolved by well scanned MF film (e.g. 645 or 67).
Having the MOST resolution is entirely unimportant. Having ENOUGH resolution is the only thing that matters. How big would you like to print? How close do you expect or want your viewers to view your large prints? Does your subject matter, shooting style, and presentation method benefit from higher resolution (e.g. grand landscapes often do, but impressionist motion-blurred street photography rarely would)? If MF film, plus the scanner that is reasonable for you to use, gives you enough resolution for your needs it doesn't matter if MFD would give you more.
Lenses. Lenses. Lenses. Doesn't matter a nickel how much resolution the film or sensor have if your lenses don't carry it. Many medium format film lenses, even from venerable brands, even those that had a good reputation in their era, are woefully outperformed by modern lenses. This is especially true on the wider end where the most development in optical design has been made in the last two decades. The
Schneider 35LS and 45LS Blue Ring lenses, or a Rodenstock 32HR on an
Arca Tech Camera, compared to any film-era wide, are hugely better.
Want to shoot medium format film for the experience? For the lower price of entry? For the challenge? Go for it! But if you're after top resolution... no.