Case in point: I once mounted a 150mm large format lens into a cardboard box and taped some Provia 100 inside the box opposite the lens. The resulting image takes up a huge amount of film (roughly 6cm x 17cm), but despite having a decent lens, the resulting image isn't all that great... of course, a cardboard box can't keep the lens square to the box, sucks at keeping the film flat, and even if you managed to get a perfect exposure it's very hard to keep a large negative (positive in this case) flat enough to get a decent dry scan.
(Here's the image, BTW: https://www.flickr.com/photos/shivatron/2384597928 .)
When I print my MF or 4x5 images, I don't really worry about 'all the detail', since as you say, you'd need a pretty big print to really see them. I'm just happy if they look nice and sharp on the wall.
I have to give mad props to the guys still doing collodion--that is way above my pay grade, as they say. And I don't want to carry glass plates on my bike. I try to limit the toxicness of the chemistry I have in the house as much as can, but I still like doing the lab work--it is satisfying to me in a way that no digital process is ever going to be.
As for the scanner, if you don't really need a car, you can always get a Flextight. (They really are that good, but they really are too expensive nonetheless.)
That said, even with 6cmx6cm film negatives I feel like I often cannot really use the detail available. That is, unless I'm printing very large photos in a film-only workflow I don't really see all the detail. My scanner seems to be limited by the ability to keep the film flat rather than the actual scanning sensor. I don't usually bother scanning higher than 50MP.