Depends on what you value, I guess. I think Automatron is only worth $10 if you plan on using the robot crafting a lot. The attached story and quests are short and uninteresting, and not even close to being on the same level as the quests and stories of the FO3 and NV DLC - even the ones I didn't much care for like Mothership Zeta. On the other hand FO3 and NV's DLC (with the exception of Gun Runner's Arsenal) were built entirely around their respective stories and quests - more often than not in their own unique world spaces, so while I'd argue that they're better than the story and quests of Automatron there's no new features like robot crafting that you might be using for hours upon hours in the main game. Some increase the level cap, and add new perks and\or traits, and pieces of equipment that you can use outside of the DLC though.
I thought the FO3 and NV story DLC were all a better value for $10, but I'm also someone who doesn't much care for scrounging for junk to craft things out of, and who prefers structured stories and quests. I thought I got my money's worth with the FO3 and NV DLC, even the ones I didn't like. In comparison if I hadn't already bought the season pass I'd have considered the Automatron DLC a waste of $10.