Watched new players discuss the in game ramifications of the cleric/god relationship.
GM told the player of the cleric of Heironeous that had used trickery and deceit instead of valor in combat, that their dreams were being disturbed by the rumblings of thunder, and they felt their connection to their god weakening.
But here's the key, THEY CAME UP WITH THAT ON THEIR OWN, to them it was implicit in the story of being a Valor cleric.
So it doesnt matter when/if the PH or DMG says the DM can or can't, players bring their concepts of the relationship to the game from books/culture/movies, whatever, and it made sense to them.