Very durable vinyl already exists. For example, hundreds of people come into our bakery every day and stand in line, summer and winter.
Ours is still like new And it's also right in the hallway at the entrance dirty from shoes. It's also possible that because of the visual and tactile texture you can't see anything. Upstairs we have some with a harder surface, so scratches are probably more likely. I dropped a brick at one point and it left two small scratches – but the damage is much less than it would have been with tile.
Just order some samples. But a lot of sand is certainly not helpful in the long run. Ask around for companies with experience in the commercial sector to see what they recommend.