I think you will continue to struggle with the criteria you have suggested.
Personally, I would never buy an MFD because if one part goes wrong it all goes wrong.
I don't know of an MFD that does (3) Transparency/Negative scanning.
You would be better off buying separate units.
I have two Epson R220 printers and an Epson Perfection 3170 Photo scanner. Does what you list except (6), and very good quality as well.