Greetings, guest. Welcome to the Velvet Room.
My, you are certainly an unusual guest! I can't say I've ever seen one such as you enter this room before. However, every meeting in this place has a purpose. You have my full cooperation.
I will be brief. In mere days--perhaps less--your life will change radically. Your being here is one sign of that. Though I cannot say how it will change, I can say this: This room can only be entered by those bound in a contract, or those who soon will be. It is bound to your fate. We will be here as you travel down your path towards the truth, and we will guide you as much as we are able.
I look forward to working with you, Princess Sparkle. This will certainly be a fascinating turn of events.

Apparently I got featured on or near 11/2/2014! I can honestly say I never expected this to happen! Thank you to everyone who made this possible!

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

This story is a sequel to Shadow of the Sun

Story 5 of the Savage Skies series:
Autumn has arrived in Ponyville. The harvest is in full swing and all is as it should be. After enduring the trials of the past few months, Dawn Lightwing is looking forward to what promises, hopefully, to be a peaceful season before a tumultuous winter. However, the coming season has the unwelcome effect of bringing his enemies closer than he feared. However, he is fortunate to have a loving family, good friends, and somepony who is maybe more than just a friend.
The series begins in Foal of the Forest.
Now with a TV Tropes page.

Stephen finds himself as a pony in Ponyville at night while he sleeps. Convinced he's dreaming, he tries to deduce why he's having these dreams. While doing so, he's invited by the Mane 6 to join them in investigating the disappearances of ancient artifacts from museums around Equestria. Stephen must learn how to use his talents to overcome fear and exhaustion while juggling his 9-to-5 job during the day and seemingly sleepless nights under the guides of our favorite ponies.

Cover Image Sources:
http://episkopi.deviantart.com
http://sierraex.deviantart.com/

Princess Twilight Sparkle discovers a centuries-old mystery hidden in the Royal Archives. Her investigation leads through layer after layer of deception and misdirection, setting her hooves on a path that seems to be leading to a mysterious secret. Along the way, she learns that some friendships can be very, very strange.

Book 1 of the Alicorn Adventure series.

AUDIOBOOK by VisualPony
Featured at the Royal Canterlot Library
TV Tropes Page (Courtesy of Sandtalon)
Goodreads Page (Courtesy of Facedeer)
Equestria Daily Page

WARNING: Major spoilers in the comments. Takes place several months after the end of season four. (Not a Da Vinci Code crossover, BTW!)

Do you see a dark tag? No, you don't. Not dark. Well, okay, there are a couple of dark-ish bits, but that's all. Not enough to warrant a tag. Speaking of tags, there really ought to be "Badass Twilight" and "Friendshipping" ones.

Sequels and side-stories (and more) can be found here Offprint and AO3, and a hardbound two-volume set of all that can be ordered from The Ministry of Image.

My editor for the first edition of this story was Gogito, and I can't thank him enough for all the hard work he did. My editor for the revised version was PresentPerfect, and he did a terrific job of getting the story into excellent shape.