These days, I don’t think any standalone players are any good. The entire market has been in a massive race to the bottom.
Given that a Blu-Ray movie player is not much more expensive than a DVD player, I’d get one of those, so you can watch HD content. And maybe consider a 4K UHD player, if you have a 4K TV and think you might buy a 4K movie. (But 4K players cost more than “standard” Blu-Ray players and you may not want to spend the extra money for it.)
My standalone players are made by Sony, and they work well for playing discs, but don’t try using them for anything else. (They all have Internet connectivity and claim to be able to run streaming apps, but they are not even close to powerful enough to do that well.)
If you want to use your computer instead of a standalone player, you should be able to buy and use any USB DVD drive. macOS includes DVD player software, and I’ve never had a problem using it for playing video DVDs (both homemade ones and commercial ones).
If you buy a USB Blu-Ray drive, you can use it, but Apple doesn’t include any Blu-Ray video playback software. So you will only be able to play DVDs unless you get third-party Blu-Ray player software. Since I have no personal experience with this, I won’t recommend any products.