I feel like you’re the only person who’s shared my experience. I’ve used Notion relatively frequently since its launch and my biggest gripe has always been portability. I’ve been following Anytype since their announcement over four years ago (!) waiting on a beta invite and when I finally got one, spent around 40 minutes fighting through “just figuring it out”, the documentation, and YouTube videos to figure out how to add properties to a database to mimic the most basic functionality of Notion’s relationships before finally just admitting this product wasn’t it for me.
HGST personally, because my failure count over time for those drives has been in the single digits through ~60 drives in around 15 years, though every manufacturer is going to have missteps or failures. I can say I've had bad experiences with Toshiba, but I'm sure you can find someone who swears by them also. Ultimately my anecdotal evidence in either direction is an unreliable crystal ball you should take with a grain of salt.
The suggestion to check Backblaze reports is great, but I'd also recommend to vary your manufacturers if you're able and instead build your storage solution with the assumption that drives are "wear units" and will fail. If you have some redundancy built in where you're able to tolerate the failure of one (or ideally multiple) drive failures without losing data, then even though the question still matters, it matters a bit less.