Now that there are these nodes in Blender 3.4 Beta...
...is it possible to do this with Geometry Nodes or Python to happen automatically for all the faces?
Maybe with the help of this script, what I used to make those GIF-animations by hand (and used commotion add-on for offsetting the keyframes):
