I would tell you to stay away from anything that isn't enterprise level (See Western Digital SMR, Western Digital NAND ssd). Yes, it is more expensive, but you don't have to worry as much about things that I just mentioned. consumer grade stuff is bottom of the barrel.
Google: backblaze hard drive stats for 2022
This will give you a very, very clear understanding of long-term reliability of drives - it will tell you what is good, and what could be considered questionable.
On to more specifics....
Do you have a plan for your data?
If not, stop now and come up with a plan.
How important is your data? What is your back up plan? Do you know how to test your back up plan? Are you sure? Check again. Nothing is more heartbreaking than discovering that the backups that you so diligently made can't actually be read. (Ask me how I know...🙁 )
AFA brands - HGST has been my go-to. They are expensive, but I am responsible for over 50 years of family photos and home movies for my extended family. Failure is not an option.