Does too much affection really turn a lover off?

Does too much affection really turn a lover off?