Being older and worldlier now, I'm pretty certain that there is a big whopping homosexual subtext to Holmes' and Watson's relationship. I believe the canon that Holmes is asexual, and no more in love or sexually attracted to Watson than he is to any other person, man or woman. But if the Sherlock stories were set today, it would be clear that Holmes' and Watson's primary personal relationship in life is to each other. They live together for years. Watson falls in love with a woman, marries her, moves in with her, then shortly separates from her and moves back in with Holmes; where the two of them then settle back down together in perpetuity.
I think two cases could be made strongly: either the homosexuality is there in the originals, but is subtexted because of the laws and morals of the time it was written in. Or their relationship IS sexless, but it is strongly emotional on Watson's side, and on Holmes' side Watson is as important a person to him as any person is possibly important to him. While not emotionally attached per se to Watson, he knows his life would be diminished without him in it. No matter how much he teases and insults him.
I don't think that reverance or respect for the dead needs the dead to be hidden from sight completely. It is the attitude that you bring, as a witness to a dead body, that matters, not the display and witnessing of a dead body, per se.