This was for the "making friends" prompt. Princess Zipp's mane-do and coat colour struck me as a shoe-in for her to transform into a pony Joker. Since she makes her victims so happy, well Zipp the Joker fit the prompt. At least now she's good at _something_.
ChatGPT is not the droid you are looking for. It has no comprehension, just building blocks, rules and examples to copy. Story telling is an adventure of the mind. You become the story, you become the characters, you live what they live and write it down.
That's an EarthenPony sleeping Twilight on an open copy of Past Sins on top of a second print of Fallout: Equestria (in two volumes, 2014). I took that picture in 2014. EarthenPony still makes pony sculpts. The Spike was part of the Gift Set in 2011, which also included fully molded (not brushable) Celestia, Pinkie, Twilight and Applejack (no hat).
I happened on an Admin post from Archive of Our Own in a RSS feed today. Apparently, The Pony Fiction Archive has moved their content to AO3. I looked up ponyfictionarchive.net and all I got was a 403 "forbidden" page. Elsewhere I saw indications that it had been started in 2011 and that it is (was) popular in the Russian Federation. Via the Wayback Machine I saw