In my experience, the most compelling stories are the ones the players instigate on side treks/adventures of their own making, as opposed to longer, pre-plotted adventures. Adventures of this kind have given me the most fun and best memories, as both a player and GM.