I have found an ICH SATA control mode set to IDE, so changed that to ACHI. No immediate improvement, as I got "we've run into a problem and will, restart your PC" But one way or another that will get resolved in time.
"rather than be manually disconnecting and reconnecting the cables' I have much SUCCESSFUL experience in doing JUST THAT, but did eventually invest in SATA-power switches - a checkered history there, which is probably not appropriate to THIS thread, but makes interesting reading in another 'context'.
When my PC eventually recovers, I 'll see if 'MY' problem is solved or whether I need to act on your second paragraph. I'll keep you posted.