For Destiny 2: Shadowkeep, I used Substance Designer to create various maps used in the Hive "tar" material. This material is part of the greater Hive natural alchemy, and exists in both solid and fluid states, both depicted here. See attached video for a sample of the fluid sim, complete with bubbles!
Hive Tar Motion Sample (video)