Welcome to Geekhack!
Cherry switches, and probably most Cherry-compatible switches, have a 4mm stroke and actuate after 2mm. You can use O-rings to reduce the total distance to bottom out (and also reduce the bottom out sound), but they do still need that initial 2mm travel to actuate.
Topre switches are capacitive, and actuate when you bottom out.
Er, Alps are similar to Cherry, AFAIK, although with only one Alps keyboard (and that in an old typewriter of questionable workability) I have no way of testing it.
Buckling springs actuate at the bottom of the stroke too.
Cherry MY might have less travel distance, but the overwhelming majority of users despite that particular switch.
Something with scissor switches, like the Apple aluminium keyboard, has a very low actuation distance, but you might not want to go that route. AFAIK there are a few other PC-compatible keyboards with scissor switches (although it is quite possible to use an Apple keyboard under Windows, as I did for a while).