Anyone having trouble with agent collision detection in Salesforce?

Hey folks, I'm trying to learn about different support platforms and how they handle agent assignment. I was looking at Salesforce Service Cloud for a potential project at my internship.

I keep seeing mentions of "agent collision" being a problem. From what I understand, that's when two agents try to pick the same new case at the same time, right? 🤔

In a simpler system I'd maybe use a queue with a lock in a database, but I'm not sure how it's handled in these big platforms. Does anyone have real examples of running into this with Salesforce? Like, did you have duplicate work or cases getting dropped?

Trying to compare it to other systems and this seems like a key detail for routing logic.