I already know of dr manhattan, just read Divinity from Valiant and really enjoyed it’s take on a human -> godlike being. Specifically where they have and exert power over reality, rather than just having more energy to pew at a higher scale.
I always find godlike stories more intresting when it isn’t just them fighting at a grander scale and they actually use godlike powers to manipulate reality. Also when they start off as humans, arent born gods and haven’t already existed forever.
An excellent reverse take on what you’re describing: The Wicked + the Divine. Premise: every 90 years 12 gods incarnate as (adult) humans but only live for 2 years. They’re essentially treated as international pop stars when they are discovered and they always have drama with each other
I remember seeing another one where someine gets godlike powers or they can use powers but then they die after 6 months, I really don’t like superpowers or omniciense when it comes with death, just makes it feel pointless