I'd like to second the 'manufacturer doesn't matter, all drives are going to fail' line, but specific models from manufacturers will have a much higher failure rate than others.
Backblaze, for example, publishes quarterly(ish?) stats showing the drives with the highest failure rates in terms of percentages, so you can kind of get a good view on if there's a specific drive model you should maybe avoid.
Or just buy an actual enterprise drive, avoid SMR, and have backups is also a sane approach.