Star Trek: Deep Space Nine takes a drastic turn with the second season finale "The Jem'Hadar". While previous episodes are either self-contained or part of a brief or occasionally-visited Story Arc, this episode introduces a new antagonist and kicks off a Story Arc which grows increasingly important over the rest of the series.
And while the Wham quotient is only amplified with the season three opener "The Search, Part I", which ends on a cliffhanger with Sisko, Dax, O'Brien, and Bashir's seeming death or capture, the brand new Defiant seemingly destroyed, and Odo finally meeting his people.
A particularly notable example is the 2-part episode "Improbable Cause"/"The Die Is Cast", with a Holy Shit Quotient reading that's off the charts: Garak blew up his own shop, Tain is working with the Romulans to destroy the Founders, Garak is willing to forget that Tain tried to kill him and rejoin the Obsidian Order, Tain orders Garak to torture Odo and he DOES, Odo admits he wants to rejoin the Founders, Garak then protects Odo's secret and lies to Tain's face about it, the leader of the Tal Shiar is actually a Founder and the entire plot was a means to eliminate both the Obsidian Order and the Tal Shiar in one fell swoop... and the Founders plan succeeds... whew.
Season 4's "The Way of the Warrior" two-parter brings Worf onto the station and sees the Federation/Klingon alliance come to an end.
Season 5's "In Purgatory's Shadow"/"By Inferno's Light" two-parter, which acts as something of a follow-up to the Season 3 arc. Tain is alive, is being held captive in a Dominion prison and is revealed to be Garak's father. Oh, and one of Tain's cellmates turns out to be Bashir, who was replaced by a Changeling weeks earlier. Not only that, but Cardassia joins the Dominion - giving them a foothold in the Alpha Quadrant. The Federation and the Klingon Empire reinstate their peace treaty to defend against the new threat.
"Call To Arms" - The Season 5 finale: the Dominion attack Deep Space Nine... and retake it, returing Dukat to command, the Wormhole is mined, cutting off access to the Gamma quadrant, and Jake Sisko stays behind on the Dominion-occupuied station.
"In the Pale Moonlight" is one giant Wham Episode. It starts with Sisko trying to come to terms with something disastrous he's done and it initially looks like it's about how his meddling brought the Romulans into the war on the Dominion's side. He tried to bring the Romulans into the war, and enlisted Garak's help to try and locate evidence that the Dominion is planning to betray the Romulans. There isn't any evidence, so they decide to forge some. The Romulans see through it and vow to ruin Sisko, who accepts it's all over for him and the Federation.... and then the ship blows up, a new team of Romulans discover the forged evidence on board but can't tell it's a forgery (because the original defects could have been caused by the explosion), conclude the Dominion blew up the ship to prevent the evidence reaching Romulus, and enter the war on the Federation's side. And that's when Sisko realises that Garak did it, that this was Garak'splan all along, and now he has to live with the consequences of forgery, arson and murder. Biggest wham moment of them all? He realises he can live with it.
Not just can live with it, would do it again.
Jadzia's death. While it was pretty much well known among fans that the actress was leaving the show and they were killing the character off, the brutality of an outright on-screen murder of a main character while praying at a temple altar was jarring.