I have seen much great work done with medium formats/prime focus - the biggest issue is the flex in such a large negative, they almost always have to use vacumn backs to hold them flat during long exposures. and also there is availability and choice in film stocks, sadly theres only a few choices left - the film guys have been painted into a corner, by increments, its convert to digital or get out of dodge! the decisions out of our control - unless you want to buy a 2000 dollar dedicated neg scanner, and i'm personally not a big fan of scanned 35mm slides/negs images, which was my choice of medium (unless its something big and bright and fills the whole neg, like an aurora or great comet
) - medium format and bigger, yes, there big enough to do a nice job.
do a search in google for examples