You know how much music I buy. A lot of stuff from the 1990s and earlier now has disc rot. Even one CD I bought that was fine experienced rot a few years later, and this is why I now back everything up to FLAC ASAP.
I don't believe I've ever encountered a single console game with disc rot - Sega and Sony's manufacturing plants were pretty good at what they did. However I have found a few PC games that have died due to it.