Twilight Sparkle finds herself disenchanted, having delved into all the knowledge the ponies of Equestria have to offer her, but finding it lacking. In her despair, a spirit calling itself Mephistopheles appears before her offering her all the knowledge of her world, wanting nothing in exchange.

Sail is a pegasus. Andy is a nerd. Nika used to be a Russian intelligence agent. Hawker is a porn star.
Jones works for the CIA. Shep flies the helicopter. Jeff is a mechanic.

They fight crime. Usually.

Redheart agrees to do a favor for a hospital patient. It sounds like easy money, but when more is asked of her the nurse realizes she's stumbled into something much more complicated and dangerous than she could ever imagine. Unable to get away and unsure who to trust, her only hope for escape might lie in the contents of the mysterious Dominator File.

Cheerilee's been promoted to School Superintendent. It's a good job, but she misses being in the classroom. All that changes when Princess Luna asks the teacher to take care of a special student.

On a related note, the local vampire population increases by 100%.

The Princess asks Twilight to explore the lands outside Equestria. Nopony has any sailing experience, maps are not available, and the ship's captain is from a different dimension. What could go wrong?

Also hints of steampunk, for some reason.

Now translated into Korean

A night of tequila and bad choices lead to a man being ponyfied. He thinks it's only a dream, but is quickly labeled Ponyville's resident lunatic.

Also giant robots, for some reason.

This is a companion to my story, A Dream.
These chapters are the random stories that don't match any episode of the show.

A not so standard human-in-Equestria story including but not limited to: democracy, tequila, and robots.

Things escalate from there.

TV Tropes page

Now translated into Korean