I finished the Automatron DLC yesterday. It's fun and I'd say worth it (I got it as part of Season Pass). There's a lot of fighting, a new robot companion, some new legendary Power Armor pieces with unique bonuses, new weapons (both regular and legendary), new regular armor type ("robot") and making Codsworth or Curie into a Sentry Bot is pretty epic

There are like 4-5 quests in the chain and provide a nice challenge (unless you use some of the totally OP weapons like an explosive minigun). I actually died in the final battle once (I was careless but still). It took me like 3-4 hours to finish (I wasn't really in a hurry but did not sidetrack to anything else, except some fun with the robot companions). Oh and you can make as many new robots as you want and name each one and use as either a companion or settler.
Just remember to wear your Silver Shroud armor during the quest

The Mechanist is one of the archvillans of Silver Shroud in the Fallout universe, some cool unique dialogue is available if you wear the costume
EDIT: Imagine Curie as a dual-Shiskebab wielding Assaultron tearing everything in sight to pieces. Yep, not a problem! :awe: