So the SATA HAT has been working perfectly with 2x HDDs for a month but i have detected a problem with it. In case if I disconnect the 12v power plug from SATA HAT and reconnect it, the system powers on immediately and once booted, SATA HAT is not detected (drives are spinning but not showing up. ls...
Thanks @igorp
I was able to set the spin down time using the gnome-disk-utility and now the drives spin down at the set time.