I can remember the moment well:
Running a campaign for two years, and comming down to the last game session. Promising to all the players that the Final Battle was comming, and all questions were to be answered. It was to be an all nighter, a session to end sessions. I spent over a week preparing for it. I walked in, laden with books and papers and binders. Only to be told by the players (unanimous to a man) that they did not want to play the Final Battle, because they did not want the questions answered. The did not want to know the result of the battle, what happens to the BBEG. They wanted the mystery to remain with them, and perhaps piece everything together on their own, down the line.
Never before, or since, have I had such a profound feeling of RPG accomplishment than that night. I was touched.
Individual moments from that campaign:
- Having an NPC so beloved by the PCs that they came very near to running me out of town when he tragically died.
- Having a player/bard, while attempting to tell an internationally renown story, roll a '1' on his peform check. He proceeds to actually tell the worst tale you ever heard, had us in stiches for hours. We still talk about 'THE TALE OF THAT GUY!' to this day.
- Having a player bravely sacrifice the character he had been playing for over a year and a half for an NPC.
- A player who had a wolf animal companion, who stole a pastry, and then became addicted to them. The wolf was known as 'Pastry Guy' from there on out.
Edit: And oh, yes as a player: The Holy Head-Butt of Pelor
I had a Paladin who had a spell called divine might or something like that (it's been awhile). It allows you to sacrifice 2 HP to add 1d6 of damage on your attack. Up to 10 HP, for 5d6. I had it running max once, when we were captured and tied up. I aske the DM, 'does it work on touch attacks?' He said "Im not sure, but your hands and feat are tied' "Ok, I head-butt a guard when he gets close" Took the DM completely off guard, to which he responded 'um, ok, he kind of just....... explodes' It was great. Of course, our captors performed a coup de grace, but hey, totally worth it.
Many more moments, but these are the reasons I play!!