In terms of purpose, it can be used to construct large world terrain, special effects, concept design, buildings, roads, and other random magic things.
Whether to use it depends on your favorite workflow or your demand.
These procedural generated things are designed to help developers or artists save time, improve efficiency, and make iterative prototypes,but it may bring repetition and boredom.
Some hard-to-learn tools like Houdini need some computer graphics knowledge and spend your moths learning it.And some easy-to-learn tools are just need your creativity.