In most if not all cases a good quality scan depends on the scanning application as much as the scanner itself. For many years I've been using Silverfast Scanning software from here -
https://www.silverfast.com/ with excellent results for both reflective and transparent(film) materials on an Epson V750 scanner. I also use an older Epson Expression 1680 with Silverfast for oversized originals. For 35mm film I was using a Nikon 4000ED scanner and produced great scans with the Nikon Scan software until Nikon decided to stop supporting Nikon Scan. Recently I've been experimenting with VueScan for the 4000ED but so far not impressed with that combo. Probably need to experiment further with some of the settings.
The other two excellent suggestions are a good place to start as well. However, one issue I have with the Kenneth Lee approach is in the verbiage. He tends to replace the word
Pixel with the word
Dot when referring to the resolution of a scanned image. It is true that VueScan uses DPI in lieu of PPI when referring to scan reolution, which of course is also incorrect. To the best of my knowledge scanned images as well as camera images and those from image editing programs etc. are created with Pixels, not Dots. I realize some would say I'm nit picking on this, but it's something that has always been like the sound of fingernails on a blackboard to see both PPI and DPI combined in the DPI heading, simply due to laziness. As we all realize, PPI refers to the image, where as DPI refers to the print. Printers print DOTS, not PIXELS. My mini rant