Going up to the roof for some fresh air after pulling and all-nighter, our "hero" makes the mistake of closing his eyes for a bit.
When he opens them again, he is no longer on the rooftop in Copenhagen he was expecting to be on... no he's somewhere very different, and extremely unfamiliar.
How will he react? How will the ponies react? Nothing is certain, except for one thing...

He never asked for this.

This story takes place about 8'ish years after the second season of MLP:FiM, the language of Equestria does not match any earth languages (that the main character knows of at least), and the human in question knows nothing of these ponies or the world of Equestria.
He emerges into Equestria on the roof of a building in Manehattan, not the Everfree, not Ponyville and certainly not one of the princesses' bedrooms in Canterlot Castle.

Oh! Spoilers in the comments and all that jazz, not gonna go into a whole spiel about it.

An idea which wouldn't stop bugging me til I wrote it down. After Albert Wesker is defeated,he finds himself in a strange land. A strange land known as Equestria. How will a supposed god deal with the power of friendship and magic? Rated T to be safe.

Cover picture was drawn by Astringe on Deviantart, I can't draw for the life of me. I've asked permission and everything so no lawsuits should follow.

Pulled into a strange world where myth and legends are real. Unable to communicate to the native creatures here, or even able to move for that matter... How is a human supposed to adapt to this strange world, or even manage to keep his sanity when he is encased in stone.

Fantastic, I finally get to visit my favorite cast of awesome talking ponies to have one small thing keeping me from enjoying it to its fullest. I CAN"T FREAKING INTERACT WITH ANYTHING. I guess being a ghost in Equestria isn't the worst thing that could have happened, at least I can shadow my favorite ponies and see what going on in their lives. Heh, I guess I've become the ultimate stalker, I do miss having someone to talk to that wasn't me, myself or I though.

*^*^*
Set before the events of season three.

Rated teen for now for safety, rating may change later on based on where the story goes. Characters will be added later if they get added to the story.

After a mishap involving the Transportalponder, the Courier finds himself in a place he doesn't recognize. With no way back and nothing else to do, he decides that wandering into the nearest town is the best option. Being the Courier, things aren't that simple...

A Fallout: New Vegas/My Little Pony: Friendship is Magic crossover

The style alternates between omnipresent third-person and the Courier recounting his tale to... Well, take a guess.

The royal court of Canterlot welcomes its newest member with open forelegs: the human philosopher Voltaire, from Earth.

On Earth, Voltaire is known as the greatest enemy of tyranny in the history of literature, and a legend in his own mind.

On Equestria, the court betting pool is giving him a week before the Princess banishes him to the Moon.

Note: This story doesn't have sequels per se, but there are a couple of short follow-ups set in the present day ("Parade Coverage" and "Secret Histories"), and a prequel of sorts in "At the Inn of the Prancing Pony".

TV Tropes page.

Applejack finds a strange visitor in her apple orchard one day, with even stranger stories to tell...
MLP/L4D2 crossover. My first story on FiMfiction.net! May add more tags as story progresses.
Credit for the image goes to brokencreation on DeviantArt.

Subject Delta, an Alpha Series Big Daddy, has been through a lot in his life. But this is his last stand, he and his Daughter Eleanor are going to escape from Rapture. The Pairbonding destroyed, his body tired from all the fighting ... Subject Delta won't live to see the world beyond Rapture. The ending coming near, he finds himself escaping Rapture ... to only awake in a stranger place. Will Equestria be able to handle Subject Delta?

--Crossover with BioShock 2--

Author's Note: First, criticism is highly appreciated. Second, this isn't my first fanfic rodeo, but it's the first time in English. Errors will ensue, so feel free to correct me! Third, I hope you enjoy the story!

Copyright: My Little Pony: Friendship is Magic (Hasbro), BioShock 2 (2K Games), Cover Image (The BioShock Wiki).

Tags: Crossover, Alternate Universe, Human, Dark. --Will be updated--

Characters: Subject Delta, Eleanor Lamb, Sofia Lamb, The Family, Twilight Sparkle, Spike, Rarity, Applejack, Rainbow Dash, Fluttershy, Pinkie Pie, Princess Celestia, Princess Luna, Augustus Sinclair, Yi Suchong, Andrew Ryan, Shadow Stalker. --Will be updated--

It is the year 2038, and the Earth is slowly being consumed by a space-borne monstrosity dubbed the Black Tide, which is using nanotechnology to remake the planet into something hideously alien.

Erin Olsen works for Project Harmonics, humanity's last-ditch effort to find a new world before the Tide can wipe them out. But when that world is found, and it turns out to be occupied, Erin will need to find the courage to face the unknown in order to save the inhabitants of both worlds.

(Many thanks to Easteu for the fantastic cover image for this story!)

Now with its own TV Tropes page

There is now a follow-up to this story: Sunflower - Side Projects
Sequel: Project Sunflower: Harmony

In a bout of boredom, Twilight Sparkle decides to make a clockwork automaton. When she tries to give it limited sentience, enough to follow basic instructions, she is more than a little shocked to discover that she has inadvertently put the soul of a living being within...

Now, Twilight has to cope with a living machine.

A silly little thing, not meant to be taken too seriously.