Printers normally only offer Reflective scan mode. I guess if you pay enough, there will be one that has a light in the lid for transparency / negative copying.
My Epsom 6600 give a very modest scan, but a $70 refurbished 3170 dedicated scanner, does quite well. I returned the later model Epson because the film holders were abysmally cheap and nasty.