So here is a list off the top of my head of characters come back to life in Star Trek pre-Discovery. They may be doo g it more, but I believe because it fits their theme. (Not all cages are a prison nor all loss eternal.) I’m sure I am missing some. Can you think of others?
Kirk Amok Time
Scotty The Changling
Spock The Search for Spock
Picard Tapestry
Harry Kim Emanations and Deadlock
Data /B-4
Data Times Arrow
Neelix Mortal Coil
Miles O’Brien Visionary
Everyone TNG Cause and Effect
Tasha Yar Yesterday’s Enterprise
Ballard Ashes to Ashes
Sisko The Visitor
Is it really only twice for Harry Kim? It feels like it should be more than that!
Kirk in the episode where the woman takes over his body. Isn't he basically dead in that one. Sorry can't remember the name.
Archer, Hoshi and Reed s2 ep1 get infected by alien retrovirus that turns them into aliens
Imo losing control of your body in star trek is similar enough to being dead that it could be considered the same as to effect psychologically.