That's a very opinionated question and i'll try to give the best answer i can.
My opinion is that it's a little bit of both. Stories or movies that have fantastic or unreal parts can add depth, meaning and imagination. On the other hand, if someone is looking for something straight forward and real, the fantasy aspect can become a drag to the story and a distraction.
I hope this helps, but it is very opinionated