How relevant is the Atreides' link to Agamemnon in 'Dune'?

Question

I was surprised to notice, when exploring Wikipedia's Epithets in Homer, that Agamemnon's individual epithet (or at least one of them) was "son of Atreus (Ἀτρείδης Atreídēs: also transliterated Atrīdēs)". That made me look into the House Atreides in 'Dune', and Wikipedia's Paul says:

According to Brian Herbert, Frank Herbert's son and biographer, House Atreides was based on the heroic but ill-fated Greek mythological House Atreus.

Though this is not sourced.

The Wikipedia's Paul further adds:

A primary theme of Dune and its sequels is Frank Herbert's warning about society's tendencies to "give over every decision-making capacity" to a charismatic leader. He said in 1979, "The bottom line of the Dune trilogy is: beware of heroes. Much better rely on your own judgment, and your own mistakes."

This makes it sound as if the link between Agamemnon and the Atreides is concrete, and an example of why heroes are not the best people to follow in everything. Agamemnon himself, after all, is a very complicated character though almost certainly over-haughty. How relevant are these links?

PS. It's interesting that the Atreides' link symbol is a red hawk, as below. Is this also linked to Greek mythology (the eagle being a symbol of Zeus)?

Answer 1

It is relevant because in God Emperor of Dune, Leto II reveals how, over the past 3500+ years, he has had conversations with the memories of his ancestors, including Agamemnon, and is determined that the only way humanity will survive is if he avoids the mistakes that they made during their lifetimes. That gives some legitimacy to his observations and motives.

From Wikipedia:

Using his ancestral memories, Leto II has knowledge of the entirety of human history and is able to recall the effects and patterns of tyrannical institutions, from the Babylonian Empire through the Jesuits on ancient Earth...

Answer 2

The prequels provide bit more details:

At some stage of human history, a group of rebels managed to take over the Old Empire. To cement their power, they've transferred their brains into immortal machines called "cymeks" and adopted names of famous characters from the history and mythology - Dante, Barbarossa, Ajax, Hecate...and Agamemnon, who apparently indeed could track his lineage to the ancient Greek hero. This group was later subdued when Omnius - a powerful Thinking Machine - has taken over the control. All cymeks finally met their end during the Butlerian Jihad.

Cymek-Agamemnon fathered (using his saved sperm) an unknown number of children, the last and most promising one was Vorian Atreides, the ancestor of Paul Atreides.

The hawk symbol has also a backstory: during the final Battle for Corrin, Omnius placed most of the human slaves on the orbit in small ships rigged to explode if the attack would commence as a way of deterring the attackers. Vorian, knowing that this is the only moment when humanity could succeed against the machines decided to attack, even after being called "hawk" by his friend Abulurd Harkonnen.