Only trick is they recently tend to run small for producing 4x6s for frames or scrapbooking. Letter or A4 sizes are less common and more expensive. I'd check eBay to be honest, for used stuff like the Sony UP75D.
I wouldn't buy a general consumer inkjet though.
I used to have an Epson A2 printer and a full set of inks cost more than £500.
You can get ink reservoir systems but they're messy and rather fragile. Although they do pay for themselves if you're printing at scale.
The photos they print are awesome.
But I won’t buy another one. I would tend to print in “batches”; sometimes, months apart.
Epsons don’t sit well. Each printing session would start with a whole bunch of “throat-clearing.” I’d waste a ton of ink, just cleaning the heads.
Also, the printers required a significant amount of desk space.
Epson makes some excellent inkjet printers. The cartridge based ones are expensive to run, but their eco tank offerings have pretty good output and are cheap enough to run - still no eco tank model is photo print grade, but the 5 ink version isn’t bad and not too expensive.
Ink is a messy, nasty media, but is almost unavoidable if you want good to great color quality.