I have Affinity and CC, so use (or have used them) them back-to-back.
I prefer Affinity by a factor of about 1000. I rarely use CS these days, it just annoys me. Everything is clunky and slow. I'm not nostalgic about 2002-era computing and UX design. The only consolation is that it isn't Adobe Acrobat.
But there's still some a significant number of features in CS that aren't yet in Affinity products (to be expected, considering the relative ages of the products), and if you've a specific workflow that requires CS components or plugins, that might be limiting.
I honestly can't say what has changed between Pagemaker 6.5 and InDesign whereitistoday, other than crap like liquid layout which I figure is used by about half a dozen people (and stuff to make the sort of XML that makes your brain bleed). It's an easy move to Affinity Publisher, it's pretty much all the same concepts, but everything is a lot more fluid. I've done a fair amount of high-end print stuff and it's all come out perfect.
Much the same for Illustrator to Affinity Designer.
I did find the leap from Photoshop to Affinity Photo a bit tougher, the latter has a slightly different way of doing things which chafes against two decades of Photoshop inculcation, so requires a bit more of a learning curve and occasional so that's how you do it.
They also avoid the Adobe way of doing things, and work as you'd expect a Mac or Windows application to work.