Twilight becomes alicorn of the stars. This is sort of a problem, because Luna kind of already was alicorn of the stars. Oops!

TV Tropes

This story is a sequel to Off The Edge Of The Map

When Twilight is sent with Luna on a diplomatic mission to Draconia, they quickly find themselves somewhere that doesn't appear on any map, and Luna is lost in more than one way...

Thanks to RBDash47 of Pony Fiction Archive for formatting it for submission.
Title image by Valcron

Tremendous thanks to Illya Leonov and Scribbler for the Audiobook version.
Now with a Spanssh translation by SPANIARD KIWI: https://www.deviantart.com/spaniard-kiwi/art/Apoteosis-2-3-857110089

Johnson, A.K.A. Honored Service, is starting his new, nonviolent and peaceful life in Ponyville. With the recent war between the ponies and the Nightmare fading into the history books, Honored is told to live a life of friendship and tolerance in Ponyville. He must learn to overcome problems with out the insane amount of gratuitous violence he is accustomed to. Honored is left in the care of the Elements of Harmony who are about to experience a new type of hell on Earth... a bored human soldier.

This is the third story in the Johnson, Honored Service, series. You should read the first two stories to have any clue on what the flip is happening.

1st one --> The Equestrian Honor Guard

2nd one --> Honor Above All Else

The human, Honored Service, returns to Canterlot after being thought dead for a year. This is the story of what happened to the unlucky human in that long year away from home.

First story found here. Click it.

Twilight Sparkle is called away to tend to Luna when she falls ill. As Luna grows sicker and Twilight more determined to help the younger princess, she begins to uncover dark secrets about the elements, the alicorns, and her own past.

Celestia leaves to deal with a foreign crisis, giving her sister a chance to rule alone and become more attached to the modern world. She calls on Twilight Sparkle to advise Luna, hoping her student will be able to draw Luna out of her shell. With two major threats to Equestria already defeated in the past year, it seems like the perfect time to let Luna gain some confidence and experience in the modern world. After all, what are the chances of a third disaster occurring?

Now comes with complimentary tropes.

Dismayed after her loss to Chrysalis, Celestia departs the royal wedding reception early, retreating to her royal chambers to console herself with a bottle of wine. Concerned for her sister, Luna soon follows to check up on her...

(Rated Teen for tipsy princesses, and thanks to Junglepony for the cover art!)

Twilight has something she needs to tell Princess Celestia--something that means a chance at getting everything she's ever wanted, or of losing everything she's ever had.

Something so terrifying that the only way she could say it was in a letter...and so wonderful that she had the courage to send it.

(Thanks to Cenit V for the cover!)