While often assumed to be purely about explicit erotic content, many sexual fantasies involve deep emotional connection and closeness, a new study finds. Fantasizing about someone else during partnered sex is surprisingly common and rarely signals relationship trouble.