Honestly, Celestia never bothered me too bad. I think the reason anyone may have a bad vibe about her is, because, well, she IS Celestia. And the above comment does make a good point. She can seem useless at lots of times, but in the end, she's a pretty decent character.