I have only used Affinity Photo for the past three years. I don’t use it a lot but it did enable me to import .psd files from Photoshop. I don’t need to collaborate with others so I have no idea how compatible Affinity generated .psd files are in various versions of Photoshop. there are some features I prefer in Affinity to Ps.
As for swapping to Logic, why not try Fairlight in Resolve if you want a fully featured audio suite designed for video. No need to round trip anything.