Yes it's a compromise. If you want the best photo printing possible, that would be through a dedicated photo printer, which often have more colours than the basic 4 colour printers. You can get lab like quality with the best ones, but the high end ones are expensive. If you want fast printing and scanning, low PPM costs, large paper capacities and so on, that would be with one of the office orientated MFP's. Although most of them can print photo's on photo paper as well, it's not their strength.
A few I like the look of:
Epson Expression XP-760 - quite highly rated as a photo printer. It's affordable and has a manual feed scanner. However it's mediocre on printing documents, and not cheap on ink. Review - http://www.expertreviews.co.uk/printers/all-in-one-printers/1402604/epson-expression-photo-xp-760-review
Canon Pixma MG 5750 - looks like a good budget all in one. It's not marketed as a photo printer, but it should do a reasonable job of printing photo's. Review - http://www.expertreviews.co.uk/printers/all-in-one-printers/1404314/canon-pixma-mg5750-review-our-new-best-buy
Canon Pixma TS 8050 - Bit more expensive but said to have excellent photo print quality, overall it looks like it has similar features to the XP-760, but lower ink costs. Review - http://www.techadvisor.co.uk/review/printer-scanner-copiers/canon-pixma-ts8050-review-3653732/
There are others if speed (scanning and printing) is the more important factor than photo printing. If that is what you're after then things like the Epson Workforce Pro WF-5620DWF or Canon Maxify MB2720 might be worth a look, which are more like office printers, and also have auto document feeders. They can't do borderless photo printing however.
Edited by jonuk76, 18 August 2017 - 11:30 PM.