i don't have too much of a problem with it if it's actually executed well and adds something meaningful to the plot, but to me, most of the time it just feels crammed in to add an unnecessary extra layer of "drama", especially when it's in genres that really don't call for it like action, thriller, horror, etc.
i'm usually a-okay with sex scenes though if at least one of the actors is hot lol.