But the olympian gods surely were not portrayed as perfect or almighty, but full of flaws.

Not as perfect, although their origins were, but almighty as in unaccountable, unquestionable, and above any natural limits, yes.