Medium and large format can get more because it's more film area, albeit not as much as you think in practice. It takes specific equipment and good technique, and often you are limited by the shallower depth of field or diffraction. IMO however it is much easier to achieve "reasonable" results comparable with modern full frame digital on MF/LF, because you don't need everything to be insanely high-resolution and perfectly aligned, the larger film area means that you can get good resolution out of "basic" equipment that is doing 2000-3000 dpi compared to the 4000 dpi of a drum scan that is necessary to max out 35mm.
Film also has very different technical characteristics from digital. It has an exponential "shoulder" to the exposure curve that tends to make it resistant to over-exposure, where with digital if it's overexposed it's just gone, clipped to white. It also has very different aesthetics, it just looks different (because each film stock has different exposure characteristics).
Also, some film stocks have unique frequency response curves - the astrophotography community is mourning the loss of Technical Pan film because it was perfect for photographing the hydrogen-alpha emissions of stars. It turns out that this film was developed for the National Reconnaissance Office for satellite surveillance and since they've moved to digital it's no longer being produced.