The older ones usually make you wait for a minute or two before the door is unlocked. I have one in my current apartment that doesn’t do that, but I’ve tried it a couple times and it does spill some water when you open it.
With top-loaders, you don’t even have to pause, the lid is always open; and the water stays inside, obviously.
With both my 2006 Whirlpool front loader (trash) and 2022 LG front loader (excellent), the duration from when you press the "pause" button to when the agitator stops and the door unlocks is approximately one second. No water is spilled.