Playing my current
Stellaris campaign with an Aquatics race (Fanatic Authoritarian Xenophobe), I discovered that one of my neighbors, the Finnu Trade Association, had the Doomed Homeworld origin.
I say "had", because unfortunately, they didn't colonize another planet before their home went all Krypton on them...
It's so strange: One moment, they're there; and the next...they aren't.
In an absolute sense, this is very good news: The Finnu and I didn't exactly get along, and their destruction opens up an enormous swath of territory I can expand into. (There is another empire who will also probably gain some of the Finnu's former star systems, but I'm in a far better position to take advantage of the overall situation than they are.) There's not much question that ultimately, I'm going to be the major beneficiary of their demise.
On the other hand, I can't help but feel a bit bad for them: While the Finnu Trade Association were not friends, neither were they enemies; nor were they evil. And as I've begun to explore & survey the star systems that used to belong to them, I can't help but notice a dearth of inhabitable planets anywhere near their now-shattered homeworld. I fear that they may have been truly doomed from the very beginning.