I don’t know about instant, but I’m used to getting a bunch of DNS queries within a couple minutes of issuing a certificate. I don’t think I usually get HTTP traffic.
FYI, there’s a CT feed you can stream live at https://certstream.calidog.io/. I don’t know how up-to-the-second it is, but it’s close.