Personally, I think it depends on the story. In a lot of cases, I think it's extremely out of place. Like, I feel like G Senjou no Maou didn't need H scenes at all. However, something lighthearted can have them in without feeling too out of place. Then there are the in-between cases, where the sexual content is actually relevant to the story, I think those are the best situations for H content.
But then you end up in situations like Fate/Stay Night where the H content is not only completely unnecessary, but it's also just disturbing.