I have a V500, and quite honestly i was expecting the transparency unit results to be well, crap to put it bluntly. It's not a dedicated film scanner such as the (discontinued) Nikon Coolscans, or the old but quite good Minolta Dimage. To my surprise the results were quite acceptable. You might know Vuescan, it allows combining multiple exposure passes, great for extra dense positives (or negatives), and saving into 16bpc TIFF files. Also has an infrared channel for dust removal. If you can afford the services, and have a lot of medium or large format film to scan, it might be worth it to pay for some bureau with a drum scanner to scan the entire batch, but that will have a considerable price tag attached. It still will be cheaper than buying your own drum scanner though.
I got some B&W scans of HP5+ pushed at 800 ASA and the film grain is both beautiful and shocking when compared to the noise digital cameras produce today and yet i find film grain much more acceptable than the chroma noise of digital sensors.
If you get a flatbed scanner with a transparency adapter, don't forget to calibrate it, you can get excellent quality IT8 target cheap here, for a variety of emulsions:
http://www.targets.coloraid.de/
Wolff Faust also provides custom measurements for the made targets per request. If you're going to follow this route, you need to have a fully colour managed workflow though, monitor and printer included (and dSLR if needed, but that's another story).