I agree, and so did the maker of the YouTube video I linked to. Interestingly, Wayne Pilgrim, the actor who plays Scorpius, mentions in an interview how difficult it was for him to play the character, since his motivation became, how shall I say, conflicted. It's an interesting case of the story-tellers putting an actor in a very tough spot.
EDIT: apparently Lt. Riker showed up in a DS9 episode[2]!
1 - https://en.wikipedia.org/wiki/Second_Chances_(Star_Trek:_The...
2 - https://en.wikipedia.org/wiki/Defiant_(Star_Trek:_Deep_Space...
I liked that episode and would have enjoyed Thomas Riker showing up again from time to time. Although it was another one of those "why can't they just restore dead crew from the transporter beam?" episodes. Even worse than the Scotty one since doubling Riker means that Riker's matter didn't really matter much.
Stargate: SG-1 had robot doubles who were killed off.
Season 4 was a complete disaster unfortunately. While Scorpius is fantastic, he doesn't belong on the ship and that wasn't the only nonsensical thing happening by a long shot. I was very happy we got the peace keeper wars to give a solid end to the series, even if it wasn't perfect.