i feel the same way dude, im no brad pitt either, and just like you said, women consider me a "friend" and thats it, and only on occasion. women have told me many times that i have a great sense of humour and able to make them laugh at the spare of the moment, but to date me, no chance. they keep saying "you'll find someone". but here i am at 41 years old, and STILL havent found one. so i go here to get what the majority of us are here for (sex). i feel that in one way or another, you have to pay to get laid. not always $$$.
so enclosing, i dont have any advise for you to help you out, but here to say that your not alone. ive been with 2 women from here so far, and they say im a nice guy, but i think they only say it to be polite.