It really really depends on the people in the relationship. My partner and I like to watch porn together and separately, and discuss what we like to watch. I find it does actually help the relationship, it creates closeness and helps spark discussions on what we like and don't like in bed.