It’s best to use Houdini and then export/import it as vertex animation. You can then apply your own modifications to the material that is created by Houdini VA export.to make it look right.
It is also super cheap as entire animation is done with the shader.