In my experience, it hasn't been the diagnoses I've been given that have scared people off, it's been when I become very stressed and needy and they become overwhelmed. The diagnosis adds a lot of stress on when they learn about it, but if I was acting completely 'normal' for me, they wouldn't be upset. Sometimes when I get overwhelmed with my mental health I tend to lean a little too much on others for emotional support, and for dealing with the mental health stuff. This isn't their job, and they can only help so much, as they have their own lives. I've found that when I've been able to set up a good professional support team, and use the coping skills I have, my relationships do a lot better. This way those around me aren't overwhelmed, and it can be an equal give and take relationship. Often people who are goign through high stress forget that it is important for others around them to have some of the emphasis be on them as well. If I can't spend time focusing on other people that I am close to, catching up with them, and giving them time to talk about them and their issues as well as supporting me, my relationships suffer.

I guess my point is that I hope YOU realize you're the same person as you were before, too. Just as good at the same things, just as functional, worthy and normal as you were before. Don't let the label of a diagnosis change who YOU are, just let it give you some insight into how to move forward and heal. It is too easy to get bogged down in symptoms and labels, and forget who you are without the diagnosis.
xoxo
IJ