The Odyssey version with Armand Assante as Odysseus was fairly decent entertainment.
I thought the Odyssey was a lousy movie too.
The best solution is to read the books. I would recommend The Odyssey (translation by Robert Fitzgerald) first, as being the most fun. I read it aloud to my kids when they were 10 and 12 and they really loved it. Then The Iliad, which is somewhat less accessible for moderns. And by all means The Aeneid, in the Alan Mandelbaum translation.
Maybe someone like Mel Gibson could make a decent Iliad, but the usual Hollywood directors are completely hopeless. The left haven't the slightest idea what honor is, as this review points out.