Well, none of my RPs I did in the past had a moment that I would consider as "amazing", my partners were always pretty predictable, not to mention that it became almost impossible to impress me anymore with drama, deaths or magic as people died everyday and a huge almost world destroying fight happened nearly as often.
But I had a pretty short roleplay with a new partner before I stopped roleplaying, I created a story which ended up to be pretty good, I played an OC called Gizmo, he was a god on a mountain and was responsible for the winter, the people from the local town would often come at the beginning of the cold season and as a ritual collect as many icicles as they could to offer them to Gizmo at his shrine, the amount of icicles they would offer him decided about the lenght and strenght of this winter (the more icicles, the shorter the winter).
As Gizmo was wandering the freezing mountain all winter long and sleeping during the other seasons, his body had become cold and so his heart, he didnt feel much like a living being and wasn't really able to feel empathy for the humans who came to his shrine.
One night a little girl climbed up to Gizmos shrine and offered a frozen carrot, she explains praying at the shrine, that she couldn't reach any big icicles and the small ones melted in her hand right away, so she brought a frozen carrot as it had a similiar shape, she came to the shrine hoping for Gizmo to calm the cold winds as her family lived in a little shack and they had no firewood left.
Gizmo watched the girl go and took the carrot, a god doesn't have to eat, so he never did before.
For a moment he considered just moving on the way he was, blowing cold winds over the land, but when he took a bite from the carrot, tasting something for the first time in his endless life, he felt alive for the first time, he was overjoyed when all the feelings a normal human feels came back to him, the higher gods didn't like seeing that as they knew Gizmo wouldn't have control over his emotions now, which would only influence his actions, so they stripped him off his godly powers, making him mortal.
Gizmo began to freeze horribly, he never felt how cold the winter was before, so he hid in his shringe, trying to warm himself on the candles.
Luckily over night the winds calmed and the girl that brought the carrot came to the shrine to thank the winter god, only to see a white haired man trembling in a corner of the shrine, as humans can't actually see gods, she didn't know who he was, Gizmo quickly explained what happened to him and who he was, but of course, the girl didn't believe him, he then explained how he saw her yesterday with the carrot at the shrine and that he knew about the shack and her family, so the girl took him by the hand and brought the now mortal Gizmo to her home, the story goes on of course but this was the most memorable scene.