>>4401679In inkjet, a pigment printer is visibly superior for density/saturation on matte paper. Most B&W prints will also look better from a pigment inkset, regardless of paper, because they have a more neutral tone.
Pigment prints are more UV stable too, but less durable if they'll be handled.
On gloss or lustre though, dye-based printers look just as good or better. Glossy paper has far superior dynamic range as well, and dye based prints can be handled a little bit without much harm. A dye print framed behind glass and out of direct sun will still last for years, but you should keep a duplicate print of anything really important stored in a folio.
Dye printers are MUCH less prone to clogging. This is very important for a home printer which (be honest) will be used infrequently. You may as well yeet your Pixma Pro 1100 into the trash if you don't print anything for 6 months and the head clogs. Ask me how I know.
Sharpness-wise, any of the modern multi-ink Canon or Epsons deliver the same results, and there's not really any consumer technology that beats them. I have a Canon Pro 100S, which is 12-year old technology now; it's essentially equal to the very best and newest 14-pigment Canon models for sharpness.
Commercial-tier machines aren't sharper, they're literally the same tech scaled up for roll paper and bigger ink tanks. What that does mean though is that they will give the same "check details with a loupe" resolution over a 6-foot wide print if your file has the meat in it.