I ought to warn that the connectors to a SATA drive are pretty flimsy. It's not so bad if you're using a USB adapter because it's one wide plug, covering both power (7 connectors) and data (15). SATA drive connectors

But the power plug particularly is very easy to break when it's on a too-short cable from the PSU and you can't see what you're doing. I've broken one and it was hard to get it to maintain contact once the plastic bit was missing.

The mobo end is fairly robust. I've seen two types - one just pushes in and the other has a squeeze-lock mechanism.

My 2006 spare desktop recently failed, so I no longer have any of the old IDE ribbon cable drives. They could be difficult to plug together, let alone the master/slave/jumpers malarky, but at least they stayed plugged!