I am trying to create an effect I saw on manvsmachine (linked below) and I am struggling. Does anyone have any advice on where I can learn to create such an effect or how to improve my version? I have no idea if the problem is the materials the foam the lighting or my sim and I am so lost.

Any advide would be greatly aprreciated. Thanks in advance!

FLIP divergence field/attribute for the filling up and some sort of vortex-like force for the spinny bit. That should be a good starting place.