For a human that ended up in an alien world full of talking ponies, you've been living a surprisingly boring life. Sure, you have friends and go on adventures and stuff, but you don't really have a "purpose" per se. At least, you didn't until about a month ago, when a "heinous villain" that had been turned to stone went missing from Canterlot. Now, there's a washed-up queen crashing in your basement and stealing your love.

If only you could get her to admit that she doesn't actually steal it from you.

Princess Celestia: Goddess of the Sun, ruler of Equestria, beloved Princess of ponies. She is loved by all, and loves all in return. A calm and wise ruler, she sits on the throne in Canterlot, maintaining peace and harmony throughout the land.

What most don't know is that her past is much darker: She was once a commander of legions, a warrior and scientist of unmatched skill. Thousands of monsters and abominations fell to her forces, slain in the name of an old leader, one entombed within his own throne. Free of her old form, free of the powers of Chaos, she was cast into a new realm, in a new form, with a new lease on life.

She is the God Emperor, Eternal Ruler of Equestria and Lord of the Imperium of Man.

Has a TvTropes Page. Please contribute.

Comments contain spoilers. YOU HAVE BEEN WARNED!!!

Harry Potter was a lonely boy who one day wished for a friend. Luna, trapped on the moon, wished for the same. And so their wishes are granted. How will the two deal with each other? And what about Nightmare Moon? Needless to say, their lives are going to change in both expected and unexpected ways...

Other stories in the Lonelyverse:
Hooves, Plush, and Magic: The Untold Tales
The Wizard and the Lonely Princess: Hallowe'en Special
A Nightmare Christmas

Chapters 9-11 now re-written.

An MLP/Warhammer 40K Crossover

The Iron Warriors 38th Company has landed in Equestria, entrenching themselves like a barbed hook. They hunt the aliens of the Tau Empire, intent on destruction and pillage.
A small squad is dispatched on a reconnaissance mission, only to find that there is intelligent life on this world besides the feuding space-farers.
Will these improbably adorable and friendly equine aliens turn the damned warriors of Chaos from their blood-soaked path, cleansing them of their dark legacy with the magic of friendship and harmony?

No.
No, that isn't happening.
EXPLOSIONS!!

(Dark humor warning; limited grimdark themes)
(Cover art by Nicholas Kay)
(This series now has its own TVtropes page!)
(This story is a contestant in the Tournament of Canterlot, a charity event to raise money for Syrian refugees! Go here for details and donations!)
(Featured on Equestria Daily 8/20/15 )

This story is a sequel to Princess Celestia The Changeling Queen: Stories Behind the Mask

At the Royal Wedding, Chrysalis and the Changelings were revealed to all of Equestria.

But another mask was torn away that day. A mask born for a thousand years. A mask created on one promise. A mask, that has become synonymous, fused, to its bearer.

A mask that when ripped off, causes Twilight, her friends and Luna to question everything they ever knew about the one pony, one very important pony.

At the Royal Wedding, the meaning of the phrase 'Princess Celestia' changes forever.

NOTE: Chrysalis is NOT Celestia!!! That'd be impossible to pull off.

Credits to: Plainoasis for the design of the cover art
Note 2: Original cover art here: https://angelea-phoenix.deviantart.com/art/Contest-entry-Changeling-Celestia-337023552

Pre-read/edited by Zervziel,
Blankscape,
FinalFan,
Courage Fire
Aurora Borealis

Side Stories to this can be found: here.

An audio-reading on youtube up to Chapter 21 is up by StraightToThePoint Studios. I'm aware there are others but this is the nearest complete one: [embed]https://youtu.be/X3eMW673CSY[/embed]

There are also 2 print versions of Princess Celestia:The Changeling Queen. Nonexistent Publications run and Ministry of Image's run.

Contribute to the TV Tropes Page (thanks to Babs_Seed72 for getting it up)

Since Anonymous has arrived in Equestria, he’s made little effort in forming friendships in the land most representative of it. Through his abrasiveness and social isolation, he has actively avoided public gatherings, parties, and even simple conversations. Thus, Celestia decides to take on the teaching role once more and show Anonymous how magical friendship can be. 

Edit: Caught another feature. Nice.

Mark Wells was a klutz, but even he could not imagine stumbling into a mirror that he had just bought at an antique store and ending up in a world of colorful equines, not to mention gaining hooves and wings at the same time. And whoever heard of green fur on a horse? Perhaps the great and powerful Princess that the guard was taking him to would have some answers because he sure didn't!

An alternative version of canon events with humorous twists. Written in collaboration with Airy Words.

Cover art by Mix-up and their DeviantArt account is Amalgamzaku.

Book One: Chapters 1–33
Book Two: "Further Off The Mark": Chapters 34–69
Book Three: "On The Mark": Chapters 70–100

Sex tag added as of chapter 32 but it's mostly due to talk. Actual sex takes place "off camera".

Harry Dresden, Chicago's only professional wizard, accidentally travels to Equestria after being attacked in the Nevernever. Twilight is none too amused with their newest 'guest', but trouble is brewing. Somepony is planning something sinister and the mane six may need Dresden's help however little some of them want it.

Story Image by: Lynxgriffin
Cover arrangement by: Novel Idea

Everypony has a story. Some tell of heroic feats and grand adventure. Others tell of villainy against the forces of Harmony. The story of an average guard, however, is one of obscurity. They live in the background, unnoticed but ever-present.

Silent Knight assumed his tale would be like that of his father's: join the Royal Guard and serve Equestria. He would be just another helmet and spear, part of the rank and file. And that was all he ever wanted.

However, when Captain Shining Armor asked for volunteers to form a House Guard for the recently returned Princess Luna, it was Silent's hooves that stepped forwards to set his new life in motion.

[Prototype2] / MLP:FIM crossover

Not all of Alex Mercer's "Evolved" were loyal psychopaths. Some were simply desperate people who Alex thought he could easilly control once he infected them with the "Mercer Virus". However Alex was never one for fool proof plans as he quickly finds out when only a handful of his Evolved army show up at that fateful final battle between him and Heller. Oskar was one of the many of dozens of Evolved that stood by and watched as Alex was consumed and now he finds himself in a strange cutesy land filled with talking ponies. Can this viral being find peace in Equestria or will his need to be secure get in the way?

Warning: No editor so a few grammar errors can be expected :S hopefully nothing jarring though

A big thank you to EvilBob for the picture and to Fluttershade5300 for doing some post release editing for me