> what chance do regular consumers have?
Clearly, quite a good deal, since dual-stack is the default. Nearly half the Internet[1] is using IPv6 using dual-stack just fine, and the other half is using dual stack with a LL v6 because their ISP sucks.
Like many others, my laptop routinely travels, and visits a variety of dual-stack and IPv4 only networks, just as VRBO rentals, café WiFi, airports, etc. I've never had an issue connecting to those networks that case caused by dual-stack. Far more often do some form of captive portals (from misconfigured DHCP servers to MitMs wreaking havoc) cause more failures.
> others load after a huge delay (presumably because we're waiting for an ip6 timeout of some sort)
This isn't how v6 works. It isn't impossible that there's some site out there somewhere with a broken AAAA record, but again, it is the exception given the amount of Internet-connected dual stacks. Most v4-only sites aren't going to have a AAAA.