I've seen Dreamcasts kick the bucket regularly but to be fair they were never designed to run the entire library of games off of a CD type media but rather the GD-ROM format. On top of that virtually every rip people use are downsampled, unpadded (not usually any space for it) and generally garbage.
The only console I can speak with any certainty of is the SegaCD that I've been told has a type of laser that is nearly indestructible in terms of the media killing it.