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

Living with Rainbow Dash at college

The war has gone on for far too long. To end it, Celestia just has to sign the treaty.

Exactly what it sounds like

Celestia swaps places with a woman. Also, nuclear war.

Human gets turned into pony. Then organized crime gets involved.

Exactly what it sounds like (HiE)

Most folks in town know about Longbow, even if not many really know her. She's somepony parents teach their foals to avoid. Everypony understands that she's dangerous. Everypony except Twilight, who just moved to town.

Let's drive to a brony convention with Queen Chrysalis riding shotgun

What do you do when you've been turned into a vampire? For Cheerilee, the answer is "get a second job."

In the underworld of Equestria, one mysterious pony is fearfully whispered about. Only Vinyl and Octavia know why he left a trail of destruction through the criminal ranks. Now he's back, and, well...not a he anymore.

Exactly what it sounds like

A human-turned-pony hangs out in Equestria and trolls

Rainbow wants to penetrate things and Twilight teaches her how. A few problems become immediately apparent. Too much power, too much depth, not enough material science.

The Elements of Harmony are guns