As you know I wasn’t particularly enamoured of Dumbledore’s plotting before this book and am even less so now. I don’t think he ever did really understand what he asked other people to sacrifice for him because I don’t think he ever outgrew his boyhood arrogance and feeling he knew better than others. Ariana’s death saved him from being the worst he could be, but he never still never got over that desire for power, for leadership, did he?
I think his attitude was like his father’s (extrapolating) “do what I have decided to do, accept the consequences for myself” without ever thinking about what the consequences meant for other people. Like how his father attacked those Muggle boys in revenge and ewnt to Azkaban, probably proud of himself - and left his family alone, his wife with a daughter she couldn’t manage, his sons without a father... Dumbledore did the same thing, didn’t he? It’s most clear when he asks Snape to kill him. He is obviously only thinking of using his own death to the best he can, maximising the good and avoid torture, and not about the fact that he is asking Snape to murder him.
I don't think Lucas expolored that very much (that I know of) but I think it was apparent if you look for it.
Rowling, I would say, sees Dumbledore in a similar way, and I think she actively explores it. Yes, he's good. Yes, he's the most powerful wizard in the world. But he's flawed. The world has problems, and some of those problems are the fault of the great Dumbledore.
I think Rowling dives into deep water here, and does a fine job.