On my M1 Mac mini, I have my 700 GB Photos Library on an external SSD, a USB-C 3.2 10 Gbps Samsung T7 Shield.
It works fine >95% of the time, but very occasionally it gets disconnected at sleep, giving me that error on wake. Photos loads fine and seems to work fine again when it reconnects, but I've noticed that Photos occasionally stops syncing with iCloud after this happens. It doesn't tell me there is an error. It just stops syncing. However, if I reboot, it will sometimes re-analyze the database and then will start syncing normally again to iCloud. It's not a deal breaker, but it's still annoying because I have to remember to check Photos, and reboot if necessary.
Because of this, I thought for my next Mac mini (M4) I would get a drive big enough to house my entire Photos Library. However, since I'm already using 200+ GB for other stuff, add a nearly 700 GB Photos Library, and even a 1 TB drive isn't big enough. Unfortunately, a 2 TB drive from Apple is WAY too expensive.
So instead I will just get a 512 GB internal drive and continue to use external SSDs, with the knowledge that occasionally buggy behaviour can occur.
I have three TB drives on my M1 Studio and they stay mounted. I have seen USB drives disconnect on sleep. I have not tested USB-C.
There is an app "Jettison" that can overcome this.
That's interesting. My drive above is USB 3.2 not Thunderbolt.
I will next try a USB 4 drive, and since the USB 4 is basically Thunderbolt. Hopefully this will correct the disconnect problem.
BTW, Intel says
this:
"
Both Thunderbolt™ 4 and Thunderbolt™ 3 technologies are compatible with the USB4 specification, allowing users to use Thunderbolt™ 4 and Thunderbolt™ 3 products with USB4 ports."
However, the reverse of this is not strictly true. I was looking at the OWC 1M2 USB 4 enclosure and if you connect it to an Apple Silicon Mac Thunderbolt 4 / USB 4 port, it will give you the full 40 Gbps speed. However, if you connect it to an Intel Mac Thunderbolt 3 port, it behaves like a basic USB-C drive and drops down to USB 10 Gbps speed. I'm told by experts here like
@AAPLGeek that this is a peculiarity of that specific OWC enclosure, and not a limitation of its ASM2464PD chipset, but nonetheless, weird things like this do occur when mixing and matching USB 4 and Thunderbolt ports and devices.
Nonetheless, I will try to see if a USB 4 enclosure solves the problem.