The reality is that the demands are contradictory. The qualities that make someone a dependable source of excitement are generally the opposite of those that make him or her a dependable source of stability. Seeking both in one real human isn’t much less absurd than dreaming of a partner who’s both six and five feet tall.
