Classical heroes are not generally good people in the modern sense; they are powerful people.

I think it's more apt to say that classical heroes were envisioned as 'real' people. While I think almost all people are inherently moral, nobody is "good" in the way that we often like to portray - it's a facade. That facade did not exist in the past, and I think it makes the works consequently much more human in nature.