I was hardly prepared for this...

Even though I am an avid reader of the "human finds himself into the equine society" kind of genre, most of those stories which happened to have an average human as the main character were simply.. absurd, biased against humanity or simply illogical right off the bat, mostly picturing ludicrous approaches and results, ranging from resorting to outright socipathy for no apparent reason to instantaneous mutual affinity between two alien beings who had never met before, again, for no actual reason.

As a result, those had little to none useful advices... nothing that can aid me now on dealing with the real thing, just dumb, over-the-top, childishly written perspectives... like a supersoldier's violence-ridden one-track mind, a fanboy's squeamish and annoyingly upbeat vision, a lonely human' sugarcoated dream of making out with equines and so on...

I figure I have no choice but to carry on my own particular approach by avoiding such distorted perspectives... we'll see the results soon enough.

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.

This story is a sequel to The Dresden Fillies: Strange Friends

Almost a year has gone by for Harry Dresden since he left Equestria. He'd have written, but between saving his newly discovered brother and destroying a scourge of vampires he's been a little busy. Then out of the blue he receives a strange letter from Twilight asking him to return. With no cases at the moment he eagerly accepts, but his friends aren't the only ponies expecting him. There's been a lot of rumors since his last visit and some ponies aren't too keen on seeing him come back.

A sequel to The Dresden Fillies: Strange Friends.

The star system Omega Centauri was just another oddity on a map to scientists in the not too distant future. However when they found the star was orbiting an earth-sized, earth-like planet instead of a black hole as its motion had suggested, a mission was scrambled to investigate this most unusual of celestial behaviors.

Hamstrung by politics, and nearly crippled before it began, the 'Lone Ranger' mission was reduced to just one crew member and left to his own devices.

These are the logs of Arrow 18 and its lone commander. This information is classified TOP SECRET by the Global Space Agency.

Do NOT tell the princess.

A teenage boy named Wyatt is transported to Equestria, a world with ponies, griffons, and dragons, but no humans. Now he must try to figure out how to live there, being the only human there.

Beyond Earth and beyond the Universe within which Earth exists there is a place full of love; the richest mine of love that can be found, as it is seen by those capable of utilizing it...

Within that place, specifically a part of it called the Everfree Forest, awakes one such creature: a Changeling; specifically, a Changeling who had been a human on Earth the day before. How will he survive in a body that literally needs love for nourishment, while in a world that is now wise to the Changelings' tricks and has branded them evil? Better question: Will he be able to change more than his physical appearance?

These questions are not the only thing that will plague him, for the hows and whys of his arrival and transformation are in a hurry to reveal themselves, and Equestria's heart will stop as it waits for its fate to be decided.

Now with a side story (with more to come) from other characters' POV!
POV: MANE SIX

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.

After many millenia, an unstoppable power has returned to Equestria, something the likes of which the world has never seen since it's creation. A simple human is called upon to help out with this problem, little does he know that he is part of something so much bigger than he could have ever imagined. With the aid of his new equine friends and his unrelenting power within, will he give up everything he has to save everything else?

Subject 27 is a dark, gritty, action packed and slightly sad story that revolves around a small boy possesed by a deranged demon. The poor child grows up to be a soldier of fortune and eventually is hired by a military scout interested in his particular set of skills. During his service, the man who will become Subject 27 is sent into the pony realm by a military test gone horribly wrong while nearly wiping out all of his memories of his entire life. Join Subject 27 on his adventures through the world of Equestria as he tries to reclaim the memories of his past while fighting for his life, love, and future.

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.