Hello, Energycrush and TheDevilYouKnow.
Yes, CoH is gone - for now. But, to quote Spock, "There are always possibilities."
1. Right now, Google is considering a promotional packet sent to them to try to get them to make NCSoft an offer to buy the CoH IP. (At least, I think they're still considering it; I haven't found any posts regarding anyone's having heard back from them.)
2. There are no fewer than THREE projects in the works to write a spiritual successor to CoH; when they're done by former players, you know the result will certainly be CoH-flavored, at the least.
3. It's possible that there may be an under-the-radar effort (or there may not - wink nudge) to (as I understand it) write a private-server program to make it possible to run CoH as a solo game, or as an invite-to-server game.
4. It's also possible that NCSoft may be working with Cryptic on CoH2, and therefore may have had to cancel CoH, due to contract conflicts, in order to make CoH2 possible. Your guess is as good as mine as to the likelihood (no offense intended, Joshex), but it's a comfortingly-lovely idea. The thread is
here, starting with Reply #15. However, given the players' reaction to the sunset announcement, it seems to me that NCSoft might have realized that saying something about CoH2's existence would have smoothed things out some.
5. Our local hero(es), Codewalker (and company? I don't know who else is working with him) came up with Icon. It started as a way to access the costume creator offline; as of version 1.7, you can create a toon, and run/fly around in the game-zone maps. (There are links in my Reply #1118 in the Multimedia/Titan Icon thread,
here.) You don't have powers or targets, but it's a start.

6. If you decide to play Champions Online, Star Trek Online or Neverwinter: the CoX chat channel, which you can add to your channel list, is for CoH/CoV refugees. So you'll have a bit of sympathetic company.
So hang in there, folks. The CoH/Titan community has a few cards left to play.