Here's a site for all of you people that like to ponder on the end of it all, like me.
Exit Mundi
My favorites are the slow and miserable ends, such as the Borg, the Big Expansion, and Climate Shift. Actually, now that I think about it, the Borg are pretty awesome. I could think of worse ends.