Here's what the inside of an interface unit looks like:
I can't spot anything obviously wrong, but I have no electronics expertise so what would I know. I was hoping that I could spot something glaringly wrong. I don't even know which section is dealing with audio on that PCB.
Here's an updated video of the type of sound I get when playing a CD game:
So, some sound is coming through alright, seemingly the CD audio. There's just a lot of garbage coming through and sound effects generated by the console seem to not be coming through.
Good news is, my CD-ROM2 unit works! My replacement interface unit should arrive on Monday, hopefully that one works and I'll be all set. I still wouldn't mind getting this one fixed though so I can sell it off and recoup some of my losses, maybe put some money towards a DUO-R fund so I don't have to worry about all this crap!