My CD drive refuses to work

I have gone through FOUR drives over a span of 6 months and none of them have worked. whether it was hardware failure, miscellaneous spontaneous combustion, or unknown reasons.

my current "working" drive is the "DVD Writer Model SN-208" and it reads perfectly fine but if I stupidly attempt to use the drive for its intended purpose it will say its burned perfectly fine until 99% it will say "Windows Media Player encountered a problem while burning the file to the disc" FUCK im tired of this bullshit. What drive should I get next and how do i solve my current problem?