I managed to get Color Efex Pro (Version 1.12.15 - the most current one from DxO) working with Affinity Photo (Version 1.6.7) on Mac.
Out of the box, Color Efex Pro did not work, it got stuck on "preparing image...". By using the old Plugins-Folder with the new Binaries, it prepared, loaded and edited my image.
Here's what I've done:
1.) uninstalled all versions of Nik
2.) installed the last "free" version vom DxO (https://nikcollection.dxo.com/nik-collection-2012/)
During the installation, I installed the plugins to a custom folder (as already described in this thread)
3.) copied the plugins folder (-> backup folder)
4.) uninstalled Nik Software
5.) installed the newest version of Nik Collection from DxO
During the installation, I installed the plugins to a custom folder
6.) deleted the contents of said custom folder
7.) copied my backup (step 3) to said custom folder
In one sentence: I'm using the plugins folder from Nik Collection 2012 with the newest binaries of Nik Collection by DxO.
I do not know what exactly is done by the plugins, but it seems like it's just an interface to load the binaries and transfer the image to/from the binaries, so while using an older version of the plugins, I am still using the newest binaries.
So far I did some testing with color efex pro (including multiple filters and control points), viveza and dfine (including manual mode for measuring noise) and I did not find any problems. However your mileage may vary - use at your own risk!