This corruption issue has always intrigued me.
I have always wondered whether anyone has done any investigation on an actually corrupt database to see where it has become corrupt and possibily also discover why.
Instead we all concentrate on just trying to recover from this situation - which I guess is good enough.
A little while back there was a discussion on corrupted backups and all the things that can and should be done to avoid it.
At the time I used some C code to randomly corrupt bytes here and there in a BAK file (did the backup after having done a compression).
It was amazing how much corruption you could apply and still be able to do a restore.
I too recently discovered this xvi32 tool and will now try it out on some MDF and BAK files.