I'm one of those people who are stunned and sad when anyone on a main cast or even recurring cast dies. I cried when Jadzia died even though I knew the real reason was because Terry Farrell left the show. Still...I hated that!! I also cried when Ziyal got killed.
When they killed off Janeway in the novels I was furious. But then they brought her back and had her hook up with Chakotay so I was happy about that.
They wouldn't be able to just bring a dead person back on a series like this though. Although they did with Lindsey Ballard but she wasn't main cast anyway.