Hi... forum noob, here. I really don't like using the 'cheat' console in the game, but I admit, I have had to sometimes to reset a stuck Sim.
I had a really badly timed stuck Sim once; wish I'd captured it to show here. One of the NPC Sims died while waiting for a cab outside the bookshop in Bridgeport... I'd sent one of my Sims to buy a book and then come home, but they never did! When I went to bookshop to check, she and all these other NPC Sims were staring and mourning at this floating ghost waiting on the curb for a cab. The ghost wouldn't move on and neither would anyone else, although they were all still animated. I bit the bullet, reset the Sim... and then a few days later, I see her reading a book in the park, alive and well! Or so I thought! Every time my Sim or a NPC came near her, the mourning thought bubble would appear above their heads! ZOMBIE SIM! I worried how this would affect the gameplay from there on, so I reset the Sim again and I haven't seen her since.
Has anyone else experienced this, that if you reset a ghost Sim, they come back to life... so to speak? Bear in mind, mine was a NPC and recently deceased and stuck. I imagine the odds of forcing this scenario would be quite tricky in order to test it, but I swear it really happened! Has anyone else experienced it by any chance?