I've seen the guides you're probably referring to in order to achieve this. Most of them say, enable UPnP, port forward, and/or DMZ the PS4 all at once. This seems to be a bit redundant and a tad overkill to achieve this. Not to mention the security concerns.
Having your connection set as open in Black Ops 4 might help your connection a bit in terms of connectivity to other users. I'm not a CoD player, but I'm guessing since it's Activision it runs a P2P hybrid rather than dedicated servers, except for maybe Blackout game mode? So in that aspect if you're able to achieve open and are connecting to other open users, they probably have a quality network, like a campus or corporate network, or have more technical expertise and have configured their router properly for online play and are focused on their network performance as well. That may be where the better connectivity performance wise is concerned.
As far as your speed and ping goes, the most important things you can do to improve it on PSN is use alternate DNS servers, such as Google or OpenDNS, not double NAT, and make sure the appropriate ports are open.
I'm not sure if it is possible to get an open connection in Black Ops 4 if you have a NAT type 2 connection on PSN. There are guides out there that suggest it is possible. Is there some type of NAT filtering option on the Sky router that you can turn off and see if that somehow helps you achieve this? At this point that's the only thing I can see that would be holding it up.
You're achieving a NAT type 2 connection on PSN which is a good thing. You've tried DMZ'ing the PS4 on the Sky router. You could temporarily try the overkill solution. Even temporarily enabling UPnP, if you're able to see all the forwards the game wants, then disable UPnP, and manually forward them on the Sky router.
I would recommend that to avoid double NAT or one of the previous methods listed.
Why would you need to use tftp to restore the settings? If you saved your settings from the Dumb AP mode, you can restore from LuCI. You may have to re-disable firewall, odhcp, and dnsmasq.
If this was the case I would not restore. I would start setting up the dumb AP from scratch again. Be careful this time setting up the VLAN(s). Always, have a CPU tagged/untagged and not set to off on the VLAN.