The thing to remember is, that no matter how hard you try, there will always be some people that do not appreciate what you have to offer.
On the other hand, there are ALWAYS people out there who will value your friendship and accept you as you are.
Focus on the latter, and have pity on the former.