I've only used the exact same Sim (with a slightly different name) to restart the Drifter challenge. I accidentally had my founder marry one of my Super Sims and felt that was cheating. I've used other Sims more than once for different things though. For instance, the owner of the Legacy Bachelor Challenge wanted to see what one of my contestants looked like if she were a blond. So I made her over, gave her a different name and did an R2R Eco challenge with her. Then later, I used this same Sim to start yet another R2R in Sulani.
I also made a clone of my first Super Sim and modified him to be my founder in the Apocalypse Challenge and made the first Super Sim his brother. This Sim ended up being my all-time favorite Sim I've ever made. He's in my custom template now with his brother and one other Sim as another brother. That Sim was a make-over for a CAS challenge, so he's been used over too.
Also, in the custom template save I mentioned that I use to start all my game saves, I've put other copies of many of my favorite Sims in it from other gameplay saves that are completed. They are all not-in-world, mostly homeless and sometimes take on NPC roles. It's fun seeing them around the worlds doing different things and they'll often show-up as co-workers in the GTW careers. Sometimes these Sims end up as a spouse or friend in a current save so I get to play with them again. :)