The moment of the second Storm Shadow cruise missile strike on the command center of the Russian Black Sea Fleet in the temporarily occupied Sevastopol.
The Storm Shadow have very similar capabilities to ATACMs, I don't think it will massively increase what Ukraine is already capable of doing.
I think the reason the US is dragging their feet to release them is that once Ukraine starts using them, Russia (and their allies, Iran, China etc.) will have enough data to start developing countermeasures against them.
We are seeing a very clever move away from batch delivery of weapons, toward a sustained Ukrainian production model that will be less vulnerable to allied political shifts. I notice that while the ATACMS is not headed to Ukraine yet, another large money infusion is. I wouldn't be surprised if the US is pushing hard to assist in spinning up Ukrainian production of their own Hrimm 2 missile, which has similar capabilities. While it is in service it doesn't seem to have a good production pipeline yet. If the Neptune land attack cruise missile variant is an indicator though, it may only be a matter of time before a larger and larger share of the weapons being used to encourage the occupiers to leave will be built in Ukraine. Either under license, or their own designs.
In fact Storm Shadow has a much more sophisticated warhead and using it outside of its specialised role (penetrating a building like seen here (even much more fortified ones), then detonating deep inside) because you don't have much with that range is an actual waste. But that's where ATACMs fit in perfectly.
ATACMs is more a generalized and weaker missile with a few warhead variants (mostly bomblets or unitary, fragmenting on explosion) mostly used against at best medium armored targets while doing a lot of area damage. But then it can be fired more easily from all the existing platforms using GLMRS.
Storm Shadow on the other hand is a completely difference beast. A warhead twice the size and specialised to breach very hard targets including buried bunkers, where you can even pre-program how deep it penetrates before the main charge goes off. So when you really want to hit what's deep inside a building quite precisely, this is the right tool.