My stance on the Dumbledore situation: I just can't think of any situations Rowling could have put in where his sexuality was relevant to Harry.

Yes, but it’s not the reader’s job to think of interesting storytelling, it’s the AUTHOR’s job. 

And she is one of the most capable authors alive. She’d find a way.