but we’re at the point where it feels like a lot of media are just adding in sex scenes for the spectacle of it without it serving any particular purpose for narrative development or characterization.

This has been a thing in movies since they existed. A bit less common, but still there, in books and TV. It isn’t anything new, but at least it is becoming less common.