A good resource I’ve found is Backblaze’s drive statistics reports, as they report on failure rates and issues for all of their drives by specific model: https://www.backblaze.com/blog/category/cloud-storage/hard-drive-stats/

All manufacturers can and sometimes do make trash drives, and Seagate have a number of specific models that have very low fail rates. That said, they also have a larger number of drives with high failure rates than other manufacturers. Regardless, always research the specific drive model you are considering before purchasing to avoid surprises later.