Celestia is dying. Or at least it seems so. Afflicted with a curse that is destroying her very nature, she sets a plan in action.
The Bearers of the Elements of Harmony will take the throne in her wake... Not that they know that yet...

(Takes place as an Alternate Season 3)

I've spent the majority of my life tilling the desolate land in which I live. Every day, I wake up to move useless rocks from one location to another. This is an archaic line of work that my family has clung to for generations. It is a dull, grey existence.

Today, I have woken up in a strange room, lying in a bed that isn't mine. I'm surrounded by five mares whom I've never seen in my life. They claim to be my friends, and expect me to bring joy to the hearts of everypony.

Joy? I don't think I've ever experienced this for myself, so how am I supposed to thrust it upon others?

My name is Pinkamena Diane Pie, and I'm not sure what to make of this situation.

Celestia wants Twilight and her friends to loosen up a little bit around her. Luna just wants to try the hard cider. During a surprise visit to Sweet Apple Acres at the tail end of cider season, Princess Luna has just a bit too much to drink, and when she makes a rather inappropriate joke, Twilight comes to the very uncomfortable realization that she has never seen Celestia excuse herself to use the restroom.

This is an idea that wouldn't leave my head, inspired by Fairy Slayer's "Mommy Nearest," Aldea Donder's "Alicorn," SoundofRainfall's "Play" and RainbowDoubleDash's "Lunaverse"

Alternate Universe: Instead of Twilight Sparkle, Princess Celestia made Rainbow Dash her personal student instead! Follow her through the events of the 1,000th Summer Sun Celebration. A reimagining of "Friendship is Magic"

It started out as an ordinary day for Fluttershy – waking up in her house in Cloudsdale and going to work managing the weather for Ponyville alongside her best friend Cloud Kicker. However, she finds herself troubled by feelings she can't explain, feelings that something serious is wrong. When she starts having visions of a strange life with strange ponies, she's determined to find them and find out what's going on. But how can such a timid pony convince others of what she isn't sure of herself?

Twilight isn't having a very good day. An experimental spell blew up in her face, an army of changelings is attacking Canterlot, and she just died. Yet somehow, it looks like it's going to keep going downhill from here.

Given the chance to correct what's gone wrong, Twilight swears she's going to fix all this even if it kills her. Which it will. Frequently.

Cover art by Pixel Prism
Spanish Translation
Series TV Tropes page

Frosty Mug runs the premiere (and only) watering hole in Ponyville. He's been behind the pine for years, and listened to many a sob story, and joyous announcement. Enjoy his recollections of a rather strange week in which he served a different Element of Harmony every day, and a pony he would have never thought he'd have the honor of getting drunk. These are the memoirs of a Ponyville booze vendor.

Now with bonus drinks! Consider it 'Happy Hour'!

Warning: Shipping is mentioned.

One by one, Twilight and her friends must come to terms with the consequences of being the Elements of Harmony.

These stories take place in the intervening time between Season One and Season Two,
with the exception of Ditzy Doo: Muffins, which takes place early in Season One.

The series continues in the sequel, Secrets and Lies.

Pony Psychology has a TV Tropes Page.

WANTED:

The newly crowned Princess Twilight Sparkle has set up a bold new initiative to discover new magic, and is sending out an open call to the unicorns of Equestria to apply for her research team. No experience in magical theory or research necessary. Enthusiasm and out-of-the-box thinking a must. The Equestrian government is not responsible for any physical, emotional, or magical trauma experienced during the course of the project or the application process.

Cover art by Page Turner

This story is a sequel to Ascend

Congratulations, Twilight. With Celestia and Luna on their constitutionally mandated vacation, you're in charge of Equestria. The position of Regent is an honored and hallowed one. But maybe it's a bit early to congratulate you. After all, whether it's a nobility jealous of your ascension, or a military unhappy with Celestia's decisions; one thing's certain: your reign will be anything but peaceful.