This isn't where I belong. I left all this behind years ago, moved on with my life. But a mare from my past brought me back, and now she won't let me go. So I'm stuck here, trying to make the best of it with ponies that don't understand me, don't even like me. But when something moves in the darkness, and when things go wrong in the cold, dead night, they'll turn to me to try to set things right.

Why? Because once a police pony, always a police pony.
~~
This is a spin-off story to 'Why am I Pinkie Pie?!', and will contain spoilers for that story, but it's not necessary to read that story to understand this one.
Cover art by the talented Conicer
Need more Cinnamon Swirl? Merlos the Mad wrote a fanfic of this story!

There is now a side-story: A Hard Day's Nightmare Night

Like a stallion terrified of having children, they pulled me out of retirement. I was the best Special Agent they had, which was saying a lot, because I'm about as effective at my job as a mime having a stroke, and only half as hilarious. But I've been called upon to serve my nation again, and like the gift of surprise fellatio, I am bound to serve my nation well, and hopefully without any of the implied sexual humiliation. So I gotta buckle up and prepare for survivor's guilt, just like the time I had to go up against those racially-biased SAT questions involving graphic violence, adult language, and some sexual content.
When you're in a noir situation like mine, you could only think in metaphors and similes.

King Sombra’s dark influence was obliterated by the Crystal Heart, and the villain is well and truly dead. But when he attempts to steal the afterlife of an innocent victim, a human spirit is left hurtling towards Equestria, where this unfortunate soul is revived into the only vessel available: the reconstituted body of King Sombra himself.

Thus, a cheerfully oblivious alien is crammed into the form of the most evil and malicious being Equestria has ever known. Not that Shining Armor and Cadence know this, of course. As far as they are concerned, the King is back and he’s lost his fricking mind.

Click here for the TV Tropes page!

The following transcripts are of a journal found in Ponyville on April 16th of this year. The last recorded contact with the town had been 3 days prior, on the 13th, when a team under orders from Princess Celestia was sent to look into several missing pony reports in the area. When another group of investigators were sent on the 16th, the town was found deserted. The journal’s owner is believed to be the princess’s personal student, Twilight Sparkle. None of the town’s inhabitants have been located in the weeks since.

Readings:
Nimbus Productions
Scribbler Productions

I highly recommend both of them.

A print version of all the stories in this series can be found here.

Jessica finds herself flung into a world she has little concept of. Everything is strange and new to her, but worst of all she cannot communicate with the native inhabitants. A world of monsters and sapient ponies, griffons and other assorted beasts is no place for a human girl.

How will Jessica cope? Without an understanding of their language how will she make her way in the world, will she even be able to ever communicate with them? Why was she even brought into the world and is there even a way for her to get home?

(Thanks to Tulip for the Cover image!)

(Also now apparently has a Tv Tropes page in the making. )

Now has a re-telling in progress focusing on the Equestrians' side of things, A Stranger Among the Voices

When I was little, I came to understand the true meaning about a particular trait of mine. I don’t like to talk about it much because I’m just not much of a talkative pony. Or, well, I’m not anymore, but that’s beside the point. It’s just something I find difficult to talk about, much less explain, because unlike what I see, it’s not all black and white. It’s not like anyone could truly understand my condition anyway.

Well, except for maybe her.

This story is a sequel to Innavedr

Rainbow Dash and her companions fly east.

This story is a sequel to Hard Reset

After the events of Hard Reset Twilight's life and mental well being are slowly returning to normal. Her recovery is cut short, though, when a letter arrives informing her that the time loop spell she cast is causing severe damage to space and time itself. In over her head, Twilight tries to summon anypony who will know how to fix it. The pony she gets is the last one she ever thought she would meet... and nothing like she expected him to be.

Available in Spanish thanks to dgs1993
Series TV Tropes page

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

Shining Armor learns the most important tactical lesson of his life.

Audio version! https://youtu.be/YgDr0Xc6rN8

Now with a Spanish translation by Spaniard Kiwi!