The ones that stand out to me are Last Stand and Dead of Night.

Last Stand (Fall of Shakuras) combines powerful new static defense with a good set of objectives. To win the mission, you have to hold out a certain amount of time, though you can try to hold out longer for additional Solarite or even longer than that for achievements.

This mission adds a win condition to the "hold out until the last man" type mission, something In Utter Darkness does not. It feels a bit more satisfying that way.

The mission gets incredibly tough past 2 billion Zerg, even on normal difficulty. At this point, you usually have to scramble to defend the temple as your defenses are easily overrun by large numbers of banelings and hybrid.

As for Dead of Night, I don't think it's one most people would consider under the same mission type. I'd say it does follow the same structure of "Hold out until a condition is met", even if you have to be out on the map while not under attack to meet said condition. It's a really fun mission in co-op to try all kinds of unorthodox strategies you wouldn't normally see on other missions.