I am quite a long way into being a parent - my oldest daughter is now 13. My husband also doesn't make sperm and we now have three children using the same donor. I can honestly tell you that my husband's bond with the children isn't and never has been an issue. He is an amazing dad. Although all of our children have known, in terms they understand, that they are donor conceived, they aren't really that interested in talking about it. My 13 year old, when she found out about the usual method of conception, having known how she was conceived for many years, said it was disgusting and she would be using a donor too!!
Not that many of our friends know about the donor thing, but not because it's a great secret. It just isn't the sort of thing that comes up over coffee and our very closest friends have known from the start.
It seems like the hugest thing at the time, but to be honest, it has never caused any problems. Sleeplessness and the challenges of parenthood by far outweigh anything to do with the nature of my children's conception.
I can't promise our experience would be yours, but from all I've learnt through the years, children whose parents are open with them are as well adjusted and balanced as they would be otherwise. It's those who have had things kept from them that sometimes have a very hard time with things.
Do ask anything you want-I have pretty good memories of treatment and how it went, even though it's seven years since my last child was born.