Elpenor

An ordinary, flawed, and somewhat foolish young man rather than a heroic archetype.

He was "not especially notable for his intelligence or strength," representing the average soldier rather than a grand hero

He had a weakness for wine and sensory pleasures, famously getting drunk on Circe's island and sleeping on a dangerous roof.

He survived the Trojan War and long journeys with Odysseus, showing endurance, but his absent-mindedness ultimately led to his silly and tragic death.

When his ghost meets Odysseus in the Underworld, he is earnest and desperate, begging for a proper burial so his soul can find peace. Rather than seeking glory, he just wants to be remembered.