Some few models bundle both sets of software. Flatbeds are the best, most versatile, for photo prints and documents. Sheetfeeders are becoming rare, and I don't think you can buy a handheld scanner anymore. The only disadvantage of a flatbed is the size and table space they need. Film scanners are extremely desirable for 35 mm.
Film is the first generation original image, there is no way to get better results than from film.
Generally the reflection from the lower lamp ruins image contrast from film, but it is not as simple as turning it off, the CCD needs to be calibrated from the upper lamp too. You should understand that very much better quality is possible from real film equipment. For better film results, at minimum you need a better quality flatbed model with good dynamic range for film, with real TMA that disables the lower lamp and calibrates from the upper lamp. For sufficient image size for printing, you seriously need more than 600 dpi for 35 mm too. If film is your goal, you should instead consider a real film scanner.