I find The Time of the Doctor appalling, frankly.
In terms of Moffat's "fairy tale" logic, I get it. And Matt Smith sells it.
But when you get into the implications, the problems with the episode are threefold.
One, the Doctor brings death to a town for nine hundred years. That's not "heartwarming." The Doctor positions himself as a kindly wizard to these townspeople, but he's a magnet for all the evil in the universe that's focused on this town, and people die because the Doctor is there.
Except, its
not the Doctor who causes the mayhem: The crack is. The crack brought forth the entities that gathered and they would have instigated a mass war in the village and likely exterminated everyone in it long ago, had it not been for the Doctor wanting to protect the people in it from the danger. The Doctor has
always acted as a lightning rod, but also as a shield, and his actions as entirely in-keeping with his actions in
The Snowmen and
The Doctor Falls.
If the Doctor
left, the town wouldn’t be saved - it would be annihilated. The Daleks, Cybermen, Silence, etc. are not there
because of the Doctor but because of the information leak about Gallifrey, which they think it will restart the Time War by broadcasting the name of the sole Time Lord still in the manifest universe. Also, and crucially, Trenzalore is not destroyed for 900 years. That is an extraordinary success by DW standards. Most planets the Doctor visits don’t get that luxury!
Two, the nine hundred years ultimately feels fake. The twelfth Doctor's relationship with Clara never feels like there's a nine hundred year gap in there. But, more importantly, the aged eleventh Doctor himself doesn't feel any different. He's manifestly older, yes, but those nine hundred years of death don't seem to have affected him at all. The Time War fucking broke the War Doctor by the end, but the eleventh Doctor, who brought death to a town on a personal level -- he lived with these people for centuries -- affected him not at all. At best, Moffat is simply unwilling to deal with the implications of his storytelling. At worse, he's incapable of doing so.
Admittedly, Moffat does not write trauma the way RTD does. That’s a tonal difference, not a storytelling failing however. Also, I would argue that the Eleventh is visibly changed whilst in Trenzalore, because he's stopped running. Like Ten, he was about always running and relentlessly moving along, and the rare instance he'd stay put like
The Power of Three he would scoff and moan about boring everyday life is. But by the time he's ready to die (literally on death's door) when he sees Clara as he's become William Elevenell, he quietly exhausted, with no more tricks up his sleeve.
Also...I mean, the destruction was categorically his fault. It wasn't a happenstance he stumbled about and was not reacting toward anything beyond his disgust and long experience in the war itself. In
Time he's literally reacting to the Time Lord's broadcast of his name calling. Crucially, he's trying to
prevent a Time War, when in the latter he stopped it by causing the deaths of his people and the Daleks. Major difference.
Furthermore, when Twelfth casually but rather and surprisingly often iterates that he is younger looking than he used to be (ie. in
Twice Upon a Time), he
is referring to his old self in
Time. And you mention
Name which in itself proof of Clara's deep understanding of the Doctor since during it she learns how ancient and actually emotionally unavailable he is deep within. You assume time must always equal emotional distance. DW has
never operated that way.
And three, the Trenzalore of "The Name of the Doctor" doesn't match the Trenzalore of "The Time of the Doctor." I don't think Moffat had any idea what the hell Trenzalore was or would be, it was just a MacGuffin to underlie the late Matt Smith era, and just as Moffat's "Last Day" feels smaller than the Time War RTD's era hinted at, "Time"'s Trenzalore feels too small. There is a level at which I still feel the Trenzalore of "Name" has yet to happen.
But
The Time of the Doctor changes that future. If Trenzalore looked exactly the same,
that would be the plot hole, because
Name of the Doctor show a future where the Doctor dies without regenerating and where Gallifrey is never saved by the Doctor(s) in
Day of the Doctor. Also, "feeling smaller" is actually a creative that asbolutely works, because otherwise you miss the thematic move away from spectacle toward character for one of the more bombastic incarnations ever at the end of his existence.
Is it perfect? No, it needed another 10-15 minutes to breathe and to actually show the Eleventh during that time period in Trenzalore, to showcase the character progression better. But I can't complain when the result is one of the most tightly paid-off arcs in modern Who, especially compared to RTD’s often symbolic, rather than literal, prophecies.