- If it's a single drive situation and reliability is very important, something aimed at "enterprise" tends to be a good bet. More firmware testing, more over provisioning, and so on. And if nothing else there tends to be less BS around getting warranty coverage honored. Also costs significantly more. Micron, Intel D3s etc.
- If it's multi-drive, don't focus on finding the one best brand, use ones from different major brands with redundancy. The goal isn't to try to ensure no drive failures, but rather lower the risk of correlated drive failures so that when they happen the system has time to restore redundancy and there's no issue.
- If it's single drive and some down time is acceptable for cost then just roll the dice, though even there I'd stay away from QLC and the ultra mega bargain basement stuff.
In all cases buy from somewhere reputable that actually sells drives directly, like B&H or CDW or the like. If you buy from Amazon beware of counterfeits and also "new" stuff that is heavily used. Always check SMART stats right away and make sure drive lifetime is where you expect (not hundreds/thousands of hours on something "new"). And of course, always have good backups and/or some way to rapidly bring stuff back up.