I'm using a 2019 Intel iMac with the latest version of MacOS Sequoia (15.6). Rarely have that issue with HD's, but frequenly encounter it with SSD's. It's possible they are over-drawing the port's current limits. I found that switching from a USB port to a TB port (which has higher limits) helps, but it still happens. Also, higher-power external SSD's create more issues.
Though my issue was intermitted, while yours seems repeated, so it could be something different.
What model of Mac and SSD are you using?