I'm not some old lady pearl clutcher, but most sex scenes in movies/TV shows and books I can do without. Most feel forced and just unnecessary to the plot. Some aren't, and those can be good they can move the plot and even characters along.

Like the characters of Dani and Khal Drogo in GoT. I think the progression of the sex scenes was necessary to show the development of their relationship and them and characters.

Two people running for their lives from Ninja zombies who finally find a safe place in a rotting bathroom to hide for 10 minutes, and decide to have sex after they find out each other's names is just weird to me.

Or like in the OPs examples. If my sister or kid is missing, the last thing on my mind is gonna be how hot the detective is.

"Hey, I know we just found out a murderous biker gang may have my sister, and we may never find her body or be able to prosecute them, but what cologne is that?"

I am really good friends with a guy from a friend circle that I've known since we were like 14. We're both late 40s now. We've never hooked up or had anything other than a friendship. His ex-wife had the same type of relationship with my husband from the same friend circle. When we'd run into them, it was great. No one ever got jealous, and everyone caught up, and friend pairs could have conversations without anything being weird. We still text to catch up every few months.

There are several books that could be written about this friend circle where it was just a group of friends doing things, and rarely did anyone hook up,if they did most of them ended up married. Just some guys and girls hanging out having fun and doing stuff.