I think the big one is Tony Soprano's mother, who's actress died in the middle of the series cutting her plotline short.

She was really the ultimate villain, in a show about evil gangsters. The show even jokes about how there's no point in Tony going to therapy anymore because she was the source of his issues - i.e. the entire motivating premise of the series was gone now, lol.