I'll probably recommend you to just get a HDD. It's 2X cheaper and speed doesn't really matter for running a node anyways. Your HDD will be fast enough, unless you're consistently synchronizing from scratch or reindexing where speed makes a huge difference.
It is cheaper to buy HDD but they also have maximum two year warranty now for a reason, that means they break much more after that period, like in my case, and I don't want to buy new HDD every two years
1 TB should be good for the next few years. I am running my Bitcoin node with txindex (~34 GB) and blockfilterindex (~6.5 GB) enabled, and its data folder weighs ~425 GB in total. I am also running ElectrumX which takes up around 70 GB. A Lightning Network node takes up a negligible amount of space. By the time you need more storage, 2 TB SSDs should have become more affordable.
My idea was to use this new drive for running a node and for storing some unimportant data, files, videos and music, if drive have larger capacity than 1 TB.
If you have spare power/SATA cable, try replace existing power/SATA cable on your 4TB HDD.
I have spare sata cable, but weird thing is that I can't pinpoint what the heck is wrong with him and I don't think it's cables that I checked several times.
Now doing deep scanning and checking for bad sectors again.
If you plan to use the storage for various tasks (e.g. storing video and backup OS), HDD (for NAS, server or 24/7 usage) is better option. I use 3.5" HDD for running few full nodes without problem.
Please tell me one solid affordable HDD that has more than two year warranty and I may consider it.
I can get very good Samsung SSD with five year warranty easy.
Check your cables & connectors on the drive. Disconnections / reconnections are not the way drives usually die.
Listen, I am doing regular disc scanning checks and everything was fine until recently, now I got that Error message and Crystal Disk Info showed me Caution yellow message yesterday, so there is something wrong with drive itself.
I also did a duckduckgo search and found that disconnecting like that may be a sign of dying drive...
If it was me I would split the difference and go with a 2TB Samsung SSD.
Well under $300 US I don't know where you live in the world or your financial situation, but they are all I have been using.
Samsung and Adata SSD are my first options if I decide to buy one more SSD.