Let's just say your luck with the mares isn't all that great, two months in Ponyville and you've had your heart stomped on more times than you can count. That coupled with the fact you've lost your job, your house, and have barely enough bits to feed yourself means your life isn't exactly going so great.  And after another botched attempt at a relationship you're ready to swear off of the whole dating game for good.

But after a night of drunken debauchery you awaken to find yourself in the service of Ponyville's premiere fashionista, your willing to forget your previous pledge to the single life after she proves herself to be the kindest and most generous pony you've ever met, but only time will tell if she'll be your future lover or the next in line of a long list of mare's who you'd rather forget.

On a dark night filled with even darker magics, an insane cult attempts to give Nightmare Moon a body and life of her own, utterly separate from Princess Luna. But, when the spell is interrupted by Celestia, something unexpected is created.

Now, a little black alicorn filly named Nyx finds herself living under the care of Twilight Sparkle, only to be haunted by memories and emotions from her past. Is she Nightmare Moon reborn or is she simply a doppelganger with a soul and mind of her own? Can Twilight Sparkle protect Nyx from those who refuse to see past her dragon eyes and black coat?

Or, will Nyx be forced to inherit the sins that may not even be hers and become the greatest evil Equestria has ever known?

You spent quite a bit of your time back home honing your flying skills, but an accident grounds you.  Without a place to stay any longer, you move in with your cousin, who gladly takes you in.  However, you take note of a mare in town, and you begin to wonder if there could be more to life than flying...

Sequel to The Color of Apples.  Reading The Color of Apples isn't really necessary, but I do recommend it, as some events may not make sense without the context.

As of 9/14/12 10:53 Eastern time Approval rating is 97.6804%

Source

Twilight rushes home one evening due to a horribly embarrassing event that has just transpired in her life. When Spike finally gets her to talk about it, she tells him of her newly found crush, and how she may have messed up any chance she had at a relationship. With the advice from her number one assistant and friend Applejack, can Twilight fix what happened and get a second chance with her crush?

First fanfic I've written, and a one shot at that. A sequel is in the works if this goes over well!

Credit for the image goes to cartoonlion on deviantart.

http://cartoonlion.deviantart.com/art/Night-at-Apple-Acres-208569909?offset=10

While most humans are brought to Equestria through near-death, death, or shenanigans, some are brought with a purpose.  Meet Zack, he’s young, capable, more or less polite, and our victim.  Princess Luna requires a moment’s peace, free from her sister’s pranks.  One night, Luna comes up with the perfect plan: playing matchmaker.  With her sister plotting, Celestia peacefully slumbers with dreams of mischief ripe in her head.  If only she knew just what her little sister was capable of…

This story is rated L (Luna) for infrequent strong language and shipping.

You're a letter-sorting unicorn who works at the same post office as Ditzy Doo. Sure, you're both good buddies, but a small part of you wonders if you could be something more. One day, Ditzy gives you a gift...

Source

Princess Celestia tires of constantly being surrounded by decorum, deference, and formality, and decides to take a day off from being Princess.  But visiting Ponyville incognito is harder than she expects.  Will she be able to fit in and make friends without blowing her cover?

An unfortunate event gives Princess Celestia a fresh view on her life by forcing her to see the world from a very different viewpoint. With Equestria changing around her, she is faced with a personal crisis... if she can ignore how cute a certain lavender unicorn suddenly looks to her.

Featured on Equestria Daily!

And some site about horse porn!

Liked this story? Read the sequel.

And the story this was a sort-of prequel to.

Upon eavesdropping on a conversation between Rarity and Twilight Sparkle, Spike discovers what his "true love" really thinks of him, and after reminiscing on his thoughts about it, he slowly begins to drift away from his friends. With sorrow and despair in his heart, Spike runs away from home, and runs into an old enemy that tries to help him out.

However, after realizing what she has done, Rarity begins to realize and discover that she has feelings for Spike after all, but can she save him before it's too late?

A strange occurrence left you stuck in Equestria. Awesome, right? But questions arose about the method of transportation. How did it happen? And what does it have to do with the unicorn Twilight Sparkle?

Along the way of finding answers you made new friends, discovered new things about yourself and the world you thought you had already figured out.

This is your tale.