There's a fanfic called 'Twilight's Tears of Loneliness'. It shows Twilight in a state of distress after she fails an important magic test. She cries because she feels like she has let down her mentor, Princess Celestia. The author does a great job of delving into Twilight's insecurities and how the crying is a release of all those pent - up emotions.
In some Twilight Sparkle hurt fanfictions, she could be hurt due to her own insecurities. For instance, she might push herself too hard to prove that she's a great leader or a powerful unicorn. This over - ambition could lead to her making mistakes and getting into situations where she's harmed, either physically like getting caught in a spell gone wrong or emotionally by facing criticism from others.
Fanfiction.net could be a source as well. However, the quality can vary a great deal. When searching for Twilight Sparkle and King Sombra fanfictions there, pay attention to the ratings and reviews. A high - rated story with positive reviews is more likely to be a good read. Some fanfictions might be part of a series, so you could end up finding a whole set of stories that develop their relationship over time.
Some pony - centric forums also host fanfiction. Check out Equestria Daily's fanfiction section. There are often high - quality stories about Princess Celestia and Twilight Sparkle there. These are curated by the community, so you might find some real gems.
One great fanfiction could be 'The Unspoken Tears of Severus Snape'. In this story, Snape's tears are a result of his unrequited love for Lily. His internal struggle between his loyalty to the Dark Lord and his love for Lily is so intense that it often brings him to the verge of crying. Another one might be 'Snape's Solitary Sobs' which focuses on his isolation at Hogwarts and how his past traumas make him break down in private moments. There are also stories where his crying is related to his guilt over the events that led to Lily's death.
One great 'Draco Malfoy cries' fanfiction is 'The Hidden Pain'. In this story, Draco is faced with the aftermath of the war and the realization of all the wrongs he has done. His internal struggle leads to some very poignant crying scenes that really show his depth of character.
Finding good 'Twilight Sparkle' abandoned fanfiction is not an easy task. Some of the abandoned ones could have had really unique concepts, like Twilight Sparkle being transported to a parallel universe where the rules of magic are completely different. But since they are abandoned, they remain incomplete. You could look for them in the depths of the internet, maybe in some niche fanfiction communities that might have archived such works, but it's like searching for a needle in a haystack.
One great twilight sparkle and applejack fanfiction could be 'The Adventure Beyond the Orchard'. In this story, they embark on a journey to find a lost magical artifact that could save their land. The way their different personalities, Twilight's studious nature and Applejack's down - to - earth practicality, interact during the adventure is really interesting.
You can try fanfiction platforms like FanFiction.net or Archive of Our Own. Just search for 'Demon Twilight Sparkle' on their search bars and you'll get a list of relevant fanfictions.
One example could be a story where Twilight Sparkle sacrifices herself to save Equestria from a powerful dark magic. Maybe she uses all her magic energy to create a shield that stops an evil force but in the process, it drains her life completely. Another could be a story of an incurable illness in Equestria that Twilight contracts and despite the efforts of her friends, she succumbs to it.
One great fanfiction could be 'The Burden of a Name' where Albus Severus Potter cries due to the pressure of living up to his family's name. The author beautifully depicts his internal struggle and the moments that lead to his breakdown. It's a very emotional read.