Any tips for coming up with the end-game of a campaign?

Swallowed by a purple worm