Speaking as myself and not the whole, Dynamo has been fantastic for automation of menial tasks in MEP workflows, visualization of conflict zones without technical knowledge of Navisworks, and data transfer between tables and the project itself.
Here’s a quick example. Many firms use third-party load calculation software to determine HVAC loads. A good amount of the firm is usually trained in this software and its nuances, making any transition to Revit’s load calculation software too time-consuming to implement. So, you wind up with the menial workflow of transferring your load data, in some way or form, to Revit.
If you can produce an output file from that software (like a txt, csv, xlsx, etc…), Dynamo could enable you to push all that information into Revit. This not only saves time, but also helps control inaccuracies from bad data entry (as an example, I’ve made about ten spelling mistakes typing this out that I have corrected before sending. Imagine if this was an equipment schedule, a very bad typo could possibly have financial implications!)
There is a wealth of information available through Youtube, Autodesk University, and similar sources on MEP workflows through Dynamo. I recommend checking them out, if for no other reason than to get a few ideas on useful places to start.