Spike has had it. It's not his fault the library is a shambles. In fact, he tried his very best to save it.

And now he's supposed to take the blame? Not this time! Until Twilight starts to fully appreciate his worth, Spike goes on strike!

There was a question... and Spike wanted the answer.  The curiosity of it was gnawing at his little dragon brain like gerbils in a vat of candy corn.  In desperation, he turns to Cadence for help, and she's more than happy to assist.

After all, it's just a simple question.  What's the worst that could happen?

(Takes place prior to Season 1.  Rated for scattered innuendo.)

Source

No pony is the same after witnessing a work-related death, no matter who they are. The victim was young, eager, fresh-faced, and recently hired. In his last breaths, he let out a scream so heart-rending that the employees who heard it had difficulty sleeping that night. And Rainbow Dash was no exception.

But she's not losing sleep over that. What disturbs her is something far worse—something she said afterwards.

Silence. The golden rule is silence. Silence, and obediance.

For years, you have trained as a royal guard. Now, thanks to the fortuitous return of Shining Armour, your old-time friend and Captain, you are promoted to guarding Celestia personally. What follows, though, is the discovery of a personal side to the Sun Princess that you could never have imagined, not even in your most vivid dreams.

(Character Building. Let's try it, shall we?)

She is as beautiful and graceful as the moon, and just as hard to reach. He is a young artist with much to learn about the world. When he accepts her challenge to create an artistic masterpiece, will he win her heart, or learn a terrible lesson in the nature of beauty and love?

Source

Dismayed after her loss to Chrysalis, Celestia departs the royal wedding reception early, retreating to her royal chambers to console herself with a bottle of wine. Concerned for her sister, Luna soon follows to check up on her...

(Rated Teen for tipsy princesses, and thanks to Junglepony for the cover art!)

All of Equestria is united in celebration for the return of their beloved Princess Nightmare Moon. But when Celestia and everypony else recieve her she's skeletally starved, filthy, and very nearly dead. Meanwhile, while everypony's eye is turned, a lusty Blueblood pursues Twilight Sparkle, intent on adding her bloodline to his own so his family might step closer to godhood. (Alternate Universe, there never was a Princess Luna)

Source

After a mishap with a falling star, Princess Luna crashes into Ponyville, only to be saved by Big Macintosh. Overly grateful, Luna calls upon an ancient contract which binds her to the draft pony as his personal servant. Can Big Macintosh co-exist with an overzealous moon goddess, her creepy assistant, and an army of evil looking guards long enough for Twilight to find a loophole to get him out of the pact?

Featured on 9/5/2012

He was always considered an outcast, a black sheep.  When his peers find his secret, that he likes to watch My Little Pony, they taunt and ridicule him for it.  But, after a freak accident, he is taken away to the land of Equestria.  Has he truly found his place?  Oh, and he's an ork.  That might be an important little detail.  Warhammer 40k crossover.

Source

Sometimes, all we need are a few stats to shed some light on a subject.