I don't find Aerith at all overrated. She actually seems to me as one of the more unpopular main characters of the series. I found her character pretty likeable, but some fans tend to twist her character into a Mary-Sue because of her somewhat angelic "aura".