Not really. Read All Star Superman for a great example of how you can have a story be about the fantastical and make it very human.

That story is about Superman basically becoming overexposed to sunlight in a way that makes him progressively more powerful (than Superman was already), but it is also going to kill him.

It is about what a man like that might do when he knows he is going to die and a lot of it is Superman's connection with people.