I'm about to rant now.
For the record up-front, I'm an atheist in real life. Further what I'm about to say is tuned towards a classical definition of "gods" and doesn't include stuff like the lesser place-spirits or kami or whatever.
But having said that, I like using gods in fiction. It's fun to have gods wandering around doing godly things, it's fun to try and get into the mindset of beings that have dominion over huge swaths of reality itself, and it's fun to roleplay a mortal character and their faith in a higher power, and it's fun as a DM to have a god show up to have a talk with players and get philosophical - or ridiculous or petty. And they're held in check largely because they have a set of rules that they don't violate blatantly, either because they genuinely believe in the rules or because they know of the retaliation from other gods that'll happen if they violate them.
Conversely, I hate gods like what you're describing. Gods that aren't portrayed as these grand, epic, powerful beings. Gods that seem almost powerless in an objective sense. It feels like you're trying to make mortals "matter", but you're going way too far by making gods too alien and lacking in individual agency too much.
I dunno, that's just me. My primary conception of how gods should act probably comes from watching Xena and Hercules too much as a kid, but still. You should be able to hold conversations with gods. The word "just", near-synonym with "only" or "merely", should never be used with regards to gods.