Forget about cleaning the drives for now.
To help anyone we need to know the specifics of the burner & media used.
For the DVD media you use , do as I’ve suggested previously & post the Media ID obtained from CD-DVD Speed. This app will also give model & firmware details of your burner as we are rather in the dark here.
Similar details of the CD-R media can also be obtained although not as useful as the media ID for DVD media.
Typically this sort of problem is caused by poor quality burns which is , generally, down to the burner or the media, which is why we need this detail.
BTW Sony CD-R media are not the best. For CD-R I only buy Verbatim Pastels or Super AZO.