I have all 3 though I do not use them for any production work. I hate the subscription model Adobe has forced on users but love the software, Indesign specifically.
One thing I hate about the Affinity software is how it handles colours, spots, pantones, everything. Just seems so jumbled and confusing. Have had Designer and Photo for years and bought Publisher when it came out and still cannot get use to this setup. If they fixed that it would make it much more usable for some stuff. Publisher is missing some key things that Indesign has like handling variable data, preflight and viewing separations. Publisher also can be a nightmare handling PDF's as well as it wants to make the PDF editable. Now that I think about it Affinity might have added a "pass through" method when placing a PDF to stop the software from trying to edit it... will have to check. If they have then my comment on PDF's can be ignored, if not it is a headache. Had a few PDF's get really messed up when placed in Publisher before and it would not be something I could ever trust till they stopped trying to be a PDF editor as well as a page layout app.