You're right in that switching to Link-Local Only is a workaround, but per my understanding it will not affect your connection speeds or resolution speeds. What it does is essentially disable IPv6 on the external interface of the Airport Extreme (to Cox and the outside world) while still allowing devices in your local network to use IPv6 to communicate. The DNS servers you've switched to are Google servers if I'm not mistaken, which is fine, but should not have been necessary unless for some reason Cox's legacy IPv4 DNS servers started acting up in your area.
Switching to Link-Local Only should nullify the adverse effects of Cox's rollout to IPv6. It is a workaround in the sense that it also means that your connection to the internet will support IPv4 only until this is switched back to native. However today this workaround is unlikely to cause much of an issue for the following reasons.
1) There are currently no sites or services that I'm aware of that require an IPv6 connection or that would benefit substantially from one, at least as things are now, the internet still has to maintain compatibility with IPv4 and things are likely to stay that way at least for the next few years.
2) As I understand it at one time Link-Local Only used to be the default setting on the Airports anyway when IPv6 was still largely irrelevant. Turning IPv6 off should not make much of a difference to anything until the web starts to become more dependent on it in the future.
3) There may be security concerns with having IPv6 on. As I understand it, while with IPv4 your internal addresses were not directly accessible to the outside world (both due to the way NAT works and the firewall in the router), with IPv6 that is not the case. Each device will get a real unique IP address (being able to assign unique addresses to all devices on the planet is the point of IPv6) and this IP can be directly seen from the outside world. By default the Airport will not block incoming connections to IPv6 addresses. So the level of security implemented on all of your IPv6 compatible devices will become a lot more important once it is fully enabled.
I personally didn't have a problem disabling IPv6 for now, but I will keep an eye on things and plan to re-enable it once this issue has been resolved (either on Cox's end or via a firmware update on the Airport). IPv6 is the future after all, and eventually I'm sure that eventually any internet connection that doesn't support it will start to feel quite crippled, but by my estimates we are still a few years away from that day.
I do agree with you that this is really mostly on Cox (they probably should have given people a bit more of a heads up on this), and personally I don't find being forced to use their equipment in my local network as an acceptable solution.