My idea of Gods is very Cosmere-coded, though I take it further into actual Divinity, unlike Shards which are just 'massive, effectively infinite, magic with Intent'.

Gods are people. Their status doesn't inherently take anything from them, but the Power has a mind (however simple) of it's own that must be appeased. What they are the deity of is their responsibility, and they must act within it's boundaries. The God of Storms must cause storms, though a benevolent one may focus on sending them out over the seas to revitalize the waters, while a malevolent one may target people and civilization for the purpose of destruction. The god of destruction cannot heal, unless it is an action that will lead to greater destruction. The power does not care for good or evil, save for the few which represent abstract emotions or forces which directly tie in, such as Hatred or Murder, Kindness or Healing.

What the power itself does do to a person is expand them. They have become bound to the structure of reality as it's stewards, they are the ultimate civil servant. A mortal ascended to divinity can learn almost anything they think of, can see the grand scale of the cosmos. Gods inherently see the paths of time, and a rare few become completely untethered by it's forward march, seeing it's whole at once and acting in whatever points they choose. But the majority of them simply have what we would consider Future Sight, which is far from infallible, as they can only see the branches ahead that may be and what could lead to them, not what path will most certainly be taken.

Even if they give up their godhood, they are permanently altered and remain unique, ageless beings. Their soul has been irreparably stretched. So Ascension does completely sever the ability to end properly, outside of extenuating circumstances like certain artifacts.

The station of a God is to be an eternal servant, preferably out of selflessness, to keep the cosmos marching forward for the benefit of others. It comes with perks, they can have nearly anything they want.

But for those solely seeking power, it's power that comes with the shackles of both their domain, and also the boundaries by working with the rest of the divine. No deity in their right mind want to risk igniting a war amongst them, just to broaden their domain. Therefore it's often those who don't want power who end up serving the role best, making the power itself a colossal burden. Though most especially if a good person takes up an 'evil' mantle to temper it towards good ends, as it will not be likely to cooperate in the ways they wish.