Oops - first mistake you made
Indra is not idolized or worshipped by many. Everyone knows what he did. It is no secret. We don't have all perfect no wrong doing 'God'. We have human 'Devas'. Even today women are often called 'Devi'. It is a form of respect. Not much more.
Shiva was an 'uncouth barbarian' and Sati fell for her. Nobody and I repeat - nobody is the ultimate ideal of a man. Everyone has flaws.
Mohini is an avatar of Vishnu. Shiva even spilled his seeds seeing her. Then Vishnu came back into his own form and shamed Shiva. Shows that even the high and mighty has its flaws. Nobody is perfect. Perfection is against nature, besides being subjective.
Say Krishna. Very powerful and worshipped by so many. But he did bad things too. How did he die? By the arrow of a peasant.
People worship their good deed. Not their bad ones. Einstein is taught in schools and loved by many. But he spurned 15 girlfriends and wives. Besides fathering the atomic bomb.
In Dharmic faiths 'Gods' like Brahma, Vishnu, Mahesh, Buddha, etc all have their own faults.
In contrast prophets are all knowing no mistake making perfect men that are to be emulated.
See the difference?