One of the abandonware sites I check every so often has removed the game Fates of Twinion for download. I am probably wrong about this, but I could've sworn that the publisher wasn't Sierra-Online the last time I looked. The last game this abandonware site took off was Jazz Jackrabbit at about 6 weeks before it was released on GOG.
Apparently Fates of Twinion is part of a series, the other game being Shadow of Yserbius. Shadow of Yserbius is also showing as not being abandonware, but I haven't ever checked that game on the site before, so cannot say whether, like Fates of Twinion, the download has been taken down or whether it was never available in the first place.
But, like TFISHELL said in their original post, do not get your hopes up. For those interested, the website I'm using is
http://www.abandonwaredos.com but it still has downloads available for Menzoberranzan and Dungeon Hack, so I'm not in any way saying you should download anything from them. In a perfect world, all of these so-called "abandonware" games would be available, completely legally, for digital download, ideally DRM free, and with a lot of patience, i believe they eventually will be. It's just a matter of waiting for them.
EDIT
"I am probably wrong about this, but I could've sworn that the publisher wasn't Sierra-Online the last time I looked."
I just checked MobyGames and I am wrong about that. Also, apparently, these games were more online multiplayer games than single player games, although they did have a single player mode. I'm not really that clued up on this particular series.