Question HDD suddenly stopped working on my main PC, but works in my other PC ?

[awpertunist]

My main PC has some problems with my 1 TB seagate HDD.
It was working fine until a week ago and then it suddenly stopped showing in file explorer and everywhere else. Switching cables and ports worked a few times in the beginning and everything would work normally for a few hours before it disappeared again

The hard disk works on my other PC, other hard disks work on my main PC ( same port, same cable)

Things I have already tried :

• Switched cables
• Switched ports
• Reinstalled drivers
• Tested my PSU with a power supply tester
• Switched CMOS
• Connected the hard disk on a different PC and it worked there
• Seatools long tests
• SFC
• Chkdsk

What could be the problem here?
I am using the same hard disk on my brother's PC now and the data is still there and everything's working normally
My brother's hard disk is working fine on my PC in the same port and with the same cable

 

[helpstar]

Backup all important data
Eventually the sata port of the HDD is faulty and sometimes work, sometimes not

 

[awpertunist]

Backup all important data
Eventually the sata port of the HDD is faulty and sometimes work, sometimes not

But it has worked on the other computer everytime.
Even right now, I've had it connected to the other computer for over 14 hours and it is still working.
It doesn't work right for more than 5 or 6 hours on my computer when it gets detected.
Also, I have another hard disk connected to my computer for 20 hours and that's working fine too.

 

[SkyNetRising]

It doesn't work right for more than 5 or 6 hours on my computer when it gets detected.

Can you show screenshot from HDtune - health section?
(upload to imgur.com and post link)

 

[awpertunist]

Can you show screenshot from HDtune - health section?
(upload to imgur.com and post link)

Here

Is this serious?

 

[SkyNetRising]

Doesn't seem too serious.

What model PSU are you using?
Read model name from PSU info label or make a photo of it, if possible.

Poor power delivery could be causing this.

 

[awpertunist]

Doesn't seem too serious.

What model PSU are you using?
Read model name from PSU info label or make a photo of it, if possible.

Poor power delivery could be causing this.

PSU is Corsair CX 650
I am also putting the other specs below, just in case,

Processor : Intel i5 8600k
Motherboard : Aorus Z370 Ultra gaming 2.0
GPU : GTX 1060
RAM : Corsair Vengeance 2 x 16 GB DDR4 @ 3000 MHZ



If poor power delivery was the reason, how do my other hard disks work? Even the spare one that I have connected after mine started causing issues? (using the same cable and port)
Mine still works on the other computer.
It's been like 24 hours almost since both my computers are on and the possibly faulty HDD is working on the other computer and the hard disk from that computer is working on mine. No crashes anywhere