Do women usually frown upon guys looking at ?

I know some women are turned on by as well...but i know a lot of people that say that they arent. Is it more common for women to find a man who looks at pathetic and discusting, or more misguided...or maybe it turns them on...I really don't know