It's unclear to me if the later discussion in the bug is talking about trying to better diagnose IPv6-only sites on a IPv4-only network, or if it's about the browser proactively warning users about a v4-only network, even independent of any actual errors. Proactively warning seems a non-starter, given how many warnings that would show.
Providing better errors when a site has failed to load due to v6 connectivity seems plausible. I guess it's not immediately actionable by the user, since it's only fixable by action on either the site or the ISP. But it might give a pointer to who to talk to or let us give a better explanation.
+Edward Jung may have thoughts on the UX side of that.
On the technical side, whether we can detect this case seems a question of whether we can query AAAA records more reliably now. (Is this something where Happy Eyeballs v2 would help?) If we can, it sounds like that would improve a lot of things, including allowing for better errors. If we can't, we'll probably have a hard time detecting this failure case.