In a way, Tasha Yar's fate actually worked out really well for the series
I don't know whether this is an unpopular opinion or not but I actually think that the way Tasha Yar died gave the show much higher stakes throughout it's entire run. Here is the chief security officer, main bridge crew, tragic back story, potential love interest for the robot character just slapped down by the monster of the week. It made all the subsequent dangerous situations seem much more dire because "they were willing to kill off someone in the main cast". I also think that Yesterday's Enterprise was an awesome send off for that character that let them have a heroic ending for her after all.
It was a shame because I think Denise Crosby could have been awesome as a recurring character and in my opinion, we didn't get a great strong female character in the main cast (until DS9 which is an embarrassment of riches in that department). But I maintain that casually killing off Tasha Yar made my first watchthrough of TNG much more exciting.
I don't however like the additional stretch of her half-romulan daughter. It's pretty soap-opera-ish in my opinion and tarnishes the heroic sacrifice of her character.
Soap-opera-ish is completely right - killing off a character is meaningless if you establish your writers will stoop to a fakeout or a never before mentioned sibling/twin (or clone or mirror universe version, since it's sci-fi).
Okay, but that's not really what they did with Sela.
Sela wasn't 'Tasha returned' - she had nothing in common with Tasha (in terms of personality or her role in the show) except for being played by the same actress. She clearly wasn't just a backdoor soap opera route for Tasha to return.
Also she was only actually in four episodes (on the first of which the character wasn't identified and Denise Crosby was an uncredited voice only). Sela's brief appearances were so memorable that we tend to forget how minor her role actually was across the span of TNG - Tomalak had a bigger role, for example.
Definitely all true. But the implication that she was made into a Romulan love slave, especially after having established her backstory always rubbed me the wrong way.
They didn't want to fire her, but she did want to quit. She wasn't happy with the direction they were taking her character. I wouldn't be surprised if she also had issues with the same guy McFadden did. Jadzia was killed off because Berman wouldn't let Farrell switch to being a recurring rather than a regular, which may be what you're thinking of.
From what I've read she wanted out of her contract because they were doing her character so dirty. berman took offense to that request but couldn't /wouldn't force her to stay so gave her a weak death send off that couldn't be walked back. But yeah he also ripped her comm badge off her uniform after her final shot so for sure there was bad blood.
But that's what berman do / did, he was shitty to jadzia dax's Terry Farrell too. Terry wanted to get the same kind of reduced working schedule as Colm Meaney (O'Brian) but Berman decided to fire her for asking instead. And again made it permanent with a lame death that didn't advance the larger plot.
People can have different opinions on it but once I learned the background on these character deaths I couldn't see them as anything other than petty retributions.
I don't know if this is unpopular, but I wasn't a fan of her character or the writing. Not sure how to describe it. But the whole first season was kinda off.
The show runners of Discovery have talked about wanting to create a feeling that no one, not even series regulars, were safe. They referenced Game of Thrones in that discussion, but Yar is a great example and probably would have gotten a little more love from the community.
It would be nice if the show was not afraid of killing named characters in general. Whenever someone dies it is almost exclusively a random character brought onto that episode just to die. Tasha Yar dying is more of an anomaly and never made the show feel like it had high stakes for me.