I guess I have three types of memorable moments.
One, memorable for me as a character. I was playing a half-elven bard named Beren Ritter in a home brew campaign. I was, stat-wise, the weakest party member. Despite that, luck, skill, and things just falling into place properly had me dealing the death-blow to the campaign's major villain, who had plagued the world for nearly a thousand years. Beren finally became worthy of other bards' songs.
Two, memorable for me as a DM. We had played through several pre-published adventures, and I had decided to try my hand at an adventure I had created all on my own. So, in the final, climatic battle with the BBEG, just when the party was about to lose the adventure, they won. Same old story, I know, but here's the memorable part for me--they all jumped up, cheered heartily, and had high-fives all around. Despite so many similar situations, they've only reacted like that to things I wrote myself. I took that as high praise, and it felt great.
Three, memorable because of how hard we laughed. For example, in one battle I was running, the party was just slaughtering all of their foes. It was such a one-sided battle that I lamented, with unintentional sincerity, "My people!" Everyone laughed for quite a while, and to this day players still refer to similar "my people" moments.
Another example of that third one.... For some reason that I've forgotten, someone brought up that '80s song, "Simply Irresistible." Then, several minutes later, someone was noting the fact that phantom fungi are naturally invisible. Feeling smart-alicky, I sang, "Naturally Invisible" to the tune of "Simply Irresistible." Everyone laughed, and we spent the next several minutes coming up with more lyrics. We even talked about the video, where identical pixies are swaying back and forth to the music...but you can't see them!
Ahhh.....the memories....
Thanks,
Atavar
----------
"Never get them wet. Never expose them to sunlight. And never, ever feed them after midnight." -- The Care and Feeding of a Mogwai.