That may sound crazy when I type this but here goes:
Super Power: Time Control. Like stop time, and rewind time by just from few minutes to days. Not like going to the past and future, but just for the present time.
Super Weakness: Immortality. Now you may question why should that be a weakness? Well, it is unnatural to the human life span.
There is a reason why our lives starts and ends. It's the natural order of things. Living forever will cause nothing but pain, and misery.
Where you will see many of those you know and love die one by one, free from a life of simulation, where an immortal being gets to be trapped in life forever.
You may not want to make social interactions with the next generations because you know you will have the same painful feeling of losing those you consider friends, and families. And even though you're immortal, you are not immune to physical pain, but at least you can rewind time to avoid physical pain.
The positive thing in all of this is that you get to survive and see how the end of the world looks like. Will the planet explode? Will humanity die out but the world survived but severely damaged? Or will we meet the same fate as how the Dinosaurs got wiped by a meteor?
If the world ever survived, at least i get to see the experience on how the world is recovering, and what story I get to share with new sapient beings on what was before them.