A: To refresh, The Borg and The Doomsday Machine say: If you have this and [the] Enterprise, you can discard both. Any other event that would cause this to be discarded instead just moves it to the next player.

So, no, Creeper Sweeper would not cause the Borg Cube or Doomsday Machine to go into the discard pile. They would simply move to the next player.