Does too much affection really turn a lover off?

When love turns into constant chasing, it loses its charm.