I don't think a publication should be allowed to publish intimate facts about a person without their consent, if there is no greater good at stake.

This includes irrelevant sextapes.

Also if there is a greater good at stake (for example the security of a nation) its questionable if the public needs to have access to every intimate detail, that often just contribute to humiliating the person in question.