Different stories ask for different approaches. It's kind of my standard response, but I feel it's kind of true haha
Personally, I love both. I do prefer though artists that now how to mix both kinds into a single story, like distorting a face and kind of making it rough to convey terror when all around is detailed. I think people like David Mazzucchelli and Yoshihiro Togashi are masters of this.
I think hyper realism in comics is really hard because it more often than not it conveys zero movement, and comics are so great as they thrive with an illusion of movement.
That said, I do believe there are artists that really manage to make it work. Alex Ross is not everyone's cup of tea but I think his storytelling, lighting to convey mood and body language really sets him apart. It's always clear to me what characters are feeling in Kingdom Come and they never cross the uncanny valley to me. For a bad example of hyper realism, Greg Land, and your whole argument now applies.
@avrilguarino BlackSad is sooooooo good!!