That, I object to on philosophical grounds. The gods should be mysterious and remote. Their powers and teachings open to debate and interpretation. They shouldn't be relegated to the role of monsters for high level PCs to fight.
Why?
1) Gods walking the earth has been done to death has been done to death (quite literally) in the Forgotten Realms. If they are wise (and gods are supposed to be), they will stay well out of it, for self preservation if nothing else.
2) Divine intervention devalues the agency of the player characters. They are supposed to be the heroes of the story, not pawns pushed about by deities who can't be bothered to bash the evil minions themselves.
3) Clerics are already the least popular class (speaking from experience, not dubious statistics). It's not going to help their popularity any if they get how to play their character dictated to them, in a way that not even warlocks have to suffer.
4) Authenticity. Fantasy is all the better for having a sprinkling of real world truths.
Cleric is not the least popular class, the DMG has already stated that some Gods like Lurue dwell in the material plane, same with most if not all the Mulhorandi Pantheon, what do you mean by point 4.