Is Photoshop better than Photo? Yes, but not by much.
Is Illustrator better than Design? Yes, but not by much.
Is there an annoying learning curve? Yes, but not by much.
I've put the investment into becoming proficient in Affinity and there's no looking back for me. Adobe's pricing, feature roadmap, and general performance are not even close to being worth 10x the price. If Adobe's suite was 2x, I probably wouldn't have switched, but at this point they're just squeezing small creators like myself.
And tbh now that I'm proficient with the Affinity UX, I doubt I'd switch back. It's really good!
And in some ways, Affinity's tools can even be superior (performance, ui smoothness, and even how vector art works). If you're living with a pirated version of CS5 or 6, it's worth coming in from the cold and trying Affinity.