Yeah its why nihilism is one of my most hated things in fiction and why it only ever works in genres like Horror and even than it can get tedious in a way generic happy endings do not. I find the best balance in being "grounded" without sucking the life and joy out of a story is having bad things happen, and make them actually hurt both the characters and the audience, but still having the people you root for win. It can be a bitter sweet victory, but it is done to make you know it was not easy and the characters did indeed struggle, making it all the more worth it in the end that they triumphed.An addendum:
However, I am of the mind that realism has no place in fiction. Which is part of the reason why I don't like it. The best part of fiction, that which makes it unique next to non-fiction, is the ability to put on paper the romanticized ideas of humanity. The ideals that are unachievable normally, because they set an example for us to aspire for.
Superman, most prominently, embodies this frame of thought underneath any writer who knows Superman.
The world is already miserable. Why not show us a way towards the sun, and not to subvert it by giving us wax wings that melt as we approach the divine, but by elevating us to something greater. By glorifying our imperfections into something more. That they may usurp the flawless (read: absolute certainty) through monstrous effort.