On my last project, we made a few scenes inspired by Dune 2. Here are some stills of the sequences:
We rendered it in Cycles and added camera effects in Nuke and Resolve was used for Grading.
For the sand simulations we used Houdini Grains but we hope that Geo Nodes will have such a solver in the future. What do you think of it?