The AMD CPU slowdown in Windows 11 appears to be a bit overstated. (Clickbait, to a degree.) I have no benchmarks to show how significant it is outside of some games. I haven't seen any indication that it causes program failures, so I'm not highly concerned. Whether the patches expected from Microsoft and AMD in the week of 18 October fix things, we'll see.
I'm a very amateurish hobbyist, and I don't depend on my camera or PC for income. (Outlay, yes.) As an enthusiast, I do a lot of things that would make no sense for a pro. That includes reluctance to get an Adobe subscription, even though its pricing is reasonable.
Whether Affinity Photo's lack of support for AMD GPUs is significant, I don't know. The limited amount of testing I have done with it has been fairly quick. Maybe my Ryzen 9 5950X CPU (16 cores/ 32 threads) is up to the task.