Sosilky,
Have you ever seen the movie Waiting?
Do you know the character, "Calvin?"
HE is the epitome of 'needy' - though I don't personally feel that 'needy' is the most accurate word to describe what turns women off.
I would say, "insecure."
To answer directly your question, "what turns...