If it helps sparks any ideas, using 'log stream | grep 'IOUSBHostFamily', managed to get this log which happens as soon as I connect an external ssd that """is not working""".
2024-05-30 11:34:01.970375+0200 0x115a7 Default 0x0 0 0 kernel: (IOUSBHostFamily) usb-drd0-port-ss@00200000: AppleUSBHostPort::enumerateDeviceComplete_block_invoke: enumerated 0x152d/0583/3108 (USB Storage Device / 1) at 10 Gbps
2024-05-30 11:34:01.973966+0200 0x11c41 Default 0x0 0 0 kernel: (IOUSBHostFamily) AppleUSBHostResourcesTypeC@(null): AppleUSBHostResourcesTypeC::allocateDownstreamBusCurrentGated: Client <private> is requesting 896mA wake and 0mA sleep for port 1
2024-05-30 11:34:01.973989+0200 0x11c41 Default 0x0 0 0 kernel: (IOUSBHostFamily) AppleUSBHostResourcesTypeC@(null): AppleUSBHostResourcesTypeC::allocateDownstreamBusCurrentGated: Client <private> port 1 has EDT current overrides of 3000mA wake and 3000mA sleep
2024-05-30 11:34:01.973996+0200 0x11c41 Default 0x0 0 0 kernel: (IOUSBHostFamily) AppleUSBHostResourcesTypeC@(null): AppleUSBHostResourcesTypeC::allocateDownstreamBusCurrentGated: Granting 896mA wake and 0mA sleep based on override for port 1
2024-05-30 11:34:01.974201+0200 0x11c41 Default 0x0 0 0 kernel: (IOUSBHostFamily) USB Storage Device@00200000: IOUSBHostDevice::setConfigurationGated: AppleUSBHostCompositeDevice selected configuration 1
2024-05-30 11:34:01.980203+0200 0x885 Error 0x0 0 0 kernel: (IOUSBHostFamily) AppleUSBIORequest: AppleUSBIORequest::complete: device 1 (USB Storage Device@00200000) endpoint 0x81: status 0xe0005000 (pipe stalled): 0 bytes transferred
2024-05-30 11:34:01.984139+0200 0x11c43 Error 0x0 0 0 kernel: (IOUSBHostFamily) AppleT6000USBXHCI@00000000: AppleUSBHostController::createStream: device <private> pipe <private> streamID 32 completed with 0x0
2024-05-30 11:34:01.985216+0200 0x11c43 Error 0x0 0 0 kernel: (IOUSBHostFamily) AppleT6000USBXHCI@00000000: AppleUSBHostController::createStream: device <private> pipe <private> streamID 32 completed with 0x0
2024-05-30 11:34:01.986539+0200 0x11c43 Error 0x0 0 0 kernel: (IOUSBHostFamily) AppleT6000USBXHCI@00000000: AppleUSBHostController::createStream: device <private> pipe <private> streamID 32 completed with 0x0
2024-05-30 11:34:10.261640+0200 0x6be Error 0x0 0 0 kernel: (IOUSBHostFamily) AppleUSBXHCIStream: IOUSBHostStream::abortGated: device 1 (USB Storage Device@00200000) endpoint 0x83 stream 31: aborting 1 requests