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?"