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.

Please proceed to here for reasoning behind the cancellation.

A botched viewing spell has sent Twilight Sparkle to Earth and into the care of Kyle West. Having been turned into a human, the local species, Twilight Sparkle relies on her host to help her as she finds a way back to Equestria. And, in the meantime, she decides to learn about humans and the world they live in; the good, the bad, the beautiful and the ugly.

Now With TV Tropes Page!

The prince of Mars returns to Equestria to catch up on what his sisters have been up to. But what are his true intentions?

Our favorite heroines are blasting off for a new adventure on the Red Planet...

When I was younger, Luna, and later Nightmare, told me that there were things that lurked in the darkness, within the spaces created by shadows that even they would be wary of facing at their full power. And that they would be terrified to fight then with so much of their magic locked away by the seal that the Elements of Harmony had placed upon them centuries ago. Old things... Powerful things... But we took comfort in that such things existed only in Equestria. But, as we learned on that night so close to Hallowe'en when I was ten, we were wrong...

So very, very wrong...

An apathetic young man is pulled from his home during a storm to find himself contacted by an omnipotent being, a creator. He soon learns that his existence is and will be so insignificant that his removal from Earth won’t affect things in the slightest. His new purpose? To help the creator with the building a new world.

Dropped in the new world, the young man must find his own his goal in the budding world, all while caring for an infant princess Celestia.

art by: Beavernator
cover art source : http://beavernator.deviantart.com/gallery/?offset=360#/d4mlfl8

It's been a thousand years. Princess Luna is returned, and the castle staff must scramble to see that she has servants to attend to her needs, and just as importantly, that they look the part. Of course, it turns out that it's rather difficult to find competent servants on such short notice. A hooffull of servants are chosen based on their appearance and duties, and are assigned to serve the Moon Goddess as personal retainers until more suitable replacements can be found. When coloring, Cutie Mark, and chance coincide, one of the castle's junior stewards is thrust into a role any loyal servant ought to jump at: Lunar Hoofservant. Unfortunately for Nightlight, Princess Luna is far more demanding than her older sister, and being her servant means contending with an unforgiving goddess who demands nothing short of perfection. Furthermore, somepony must be responsible for the inevitable failure. The duty of "Royal Hoofservant" just might be synonymous with "Royal Scapegoat."
Saddled with responsibility far beyond his post and expected to fail, Nightlight has no choice but to quit his post or to become the servant that Luna needs. This is the story of a pony's development from colt to stallion, and from servant to leader.
Thanks much to DirePony for the editing and story direction he's graciously provided me.
Rated 'Teen' for alcohol use, mild innuendo/sexual references, and pony-swears.
Not based on the (excellent) sci-fi novel of the same name by Robert Heinlein.

So, I'm just a regular guy, right? I mean, I'm nothing special. I'm a college guy, just starting out, and all of a sudden while writing a paper, PRINCESS LUNA falls into my bedroom! Next thing I know, I'm being pulled into Equestria, Celestia doesnt like me, and i need to help fight Nightmare moon! My first fic, so constructive criticism is appreciated.

Equestria is a real, living, breathing world of peace and freedom... or so its inhabitants think. But a secret lies forgotten beyond its boundaries. How will a pony react when they discover they don't really exist?

[This story has nothing to do with the movie Source Code, which had nothing to do with actual source code, which this story does. Pinkie Pie knows what I mean.]

Sam wakes up in Equestria stark naked and with no clue how he got there. More problematically, he seems to be in somepony's home.

Teen for nudity and the awkward situations arising from said nudity.

A rewrite of Make Friends, or Die! by Sam Polson (which has since been taken down). I liked the premise, but Sam's English was spotty and Google Translate didn't help him much. Starts going in its own direction fairly quickly.

I'd heard about the TV show My Little Pony: Friendship is Magic from my college roommate who is way too into the show. Disturbingly so, actually, but good gravy I would never watch the darned thing! What am I, five? I've got better things to do with my time than watch a silly little girl's show. However, that didn't stop... something from transporting me into the world of the show, so here I am... in Equestria... trying to get home. This is gonna be interesting.

Special thanks to GuyFace, Jack Kellar, Storm Shaker, Spiffy McSquee, and Goober Trooper for helping me with this one!