You don't need anything special based on your stated usage case.
Just buy a generic DVD player from Amazon, something between $20-25 that has a decent rating (4-5 stars).
No drivers need to be installed, this is legacy commodity hardware that Apple hasn't included in their computers for years. The guts of these drives are made by a handful of companies, they are pretty much all the same.
I have an external USB DVD burner that I purchased about seven years ago. It might be a LaCie branded drive (I forget), but they no longer market these. The guts are likely Samsung. I used it a week ago to burn a DVD (my Mac is running High Sierra).
Whatever you do, do not buy the overpriced Apple SuperDrive. Apple modified it so it only works on Apple hardware.
If you need to read Blu-ray discs, you'll need to shell out about $60 for an external USB Blu-ray player. The devices at this price range won't burn Blu-ray discs. I have one of these for the sole purpose of reading and ripping Blu-ray discs (which happens once or twice a year nowadays).
If you want to watch Blu-rays with such a reader, you'll also need to shell out some bucks to buy Blu-ray playback software. This is the main reason why Steve Jobs nixed built-in Blu-ray players in Macs. He didn't want to increase costs from required licensing fees for a format that he thought was a dead-end: optical media.