I've got maybe 800 CDs, mostly bought new and not "abused". I've been buying CDs since the early days when CDs were replacing vinyl so most of them are a few decades old.
I'd guess less than 1% of tracks on my CDs have had defects. If there's a problem, it's usually one track on a disc.
Most of these "defects" aren't audible when played on a CD player but they show-up when ripping. CD players usually have very-good error correction/error hiding. If a CD has audible errors when playing on a CD player I'll replace it. So I don't have any CDs with audible defects.
When I first started ripping AccurateRip didn't exist but the software still sometimes reports an error. In most cases when a ripping error is reported the
sound is "perfect" and it doesn't take me long to forget which ripped tracks had errors. If the defect is audible, I'll try to fix it somehow... Sometimes I'll buy a replacement (new or used), sometimes I'll buy an MP3, and sometimes I'll attempt to "fix it" with Audacity. Of course, an MP3 or a file edited with Audacity isn't "bit perfect" but I'm usually happy if it just sounds OK.
In other cases there are clicks, skips, or ripping will simply fail.
I remember 2 CDs that were good when new and then went completely bad for unknown reasons. One was a Mobile Fidelity CD that was gold-colored so it was probably burned rather than pressed. It developed several actual cracks after being stored in my car (heat, I assume). That's the only time I've seen that and I used to have CDs in my car all the time. (As far as I know MFSL only sold CDs for a short time and I only bought it because that's all the store had for that particular CD.)
I had one bad-new CD that was some kind of compilation from an "unknown" record company. It had audible defects on at least one track and the tracks on the disc didn't exactly-match the description or the tracks listed on the packaging. I ripped the good tracks and returned it.
Note that CDs can be scratched/damaged from the top/label side. The data is on the label side and the CD is read through the full-thickness of the polycarbonate. The top side is probably MORE vulnerable to damage, it's harder to see, and any attempts to polish the top can only make it worse. (The data on a DVD is in the middle of a polycarbonate sandwich and on a Blu-Ray it's on the bottom with a hard-protective coating.)
Note that FLAC can deteriorate over time unless you take specific steps to avoid it - bit flips in memory and storage are rare, but they do happen from time to time, and more often on drives approaching end of life.
VERY RARE. And hard discs are far more reliable than shiny discs. I ONCE had hard drive that was corrupting files. It was an odd setup where my older BIOS didn't support larger drives and there was some kind of "trick driver" that would get-around the size limitations.
Usually when a hard drive fails, it fails badly and if it's the system disc, usually the computer won't boot. I've had that happen a few times.
I've been using SSDs for a few years and I haven't had a problem YET, but all of the important stuff is backed-up (including my A/V files).
I've never had bits flipped in memory. Overall, digital is VERY robust. If there's a typo/error in a document or your bank account it's a good bet it's a human error.
P.S.
I'd consider ANY audible defect to be "significant" even if it's a tiny barely audible "click".