That depends on what you define your ideals as though.
An obviously moot point since that is the issue being questioned in this forum... How many times do I have to repeat this?
Don't tell me that because the bias in that video matches your own bias that makes it correct. That's not a logical argument.
Causation does not equal correlation: https://yourlogicalfallacyis.com/false-cause This is dependent on what degree a ruler rules, which as of yet there is not substantial evidence. And even if there was, it doesn't erase her past mistakes anyway.
This is really remarkable; on the one hand you attempt to preach that Celestia is a good ruler because she is able to help facilitate the magic of friendship in Equestria to its own benefit, but on the other you tell me not to conflate the influence of the two. Don't get me wrong, I wouldn't mind seeing more characters take over Celestia's responsibilities and a more diversified power base take hold. I think that would likely do Equestria some good and consequently I hope Twilight new role will be more efficacious than her mentors. I also recognize Celestia can't handle all the problems herself(a flaw that's pretty clear ) but when she continues to make mistakes and endanger her country both through her actions and inaction... That's when I take the most issue with her position.
And you apparently demand very little... Odd considering you appear to have such esteem for her. The writers and not the character? If you're going to go that route then I'll say the blame falls on both, because the character is of course a product of the writers. But so what? i don't see you writing appraisals of the writers for Celestia's achievements, you seem to be endorsing a double standard: Blame the writers, praise the character. I won't partake in that hypocrisy.