I have to say the biggest mind blowing season finale was at the end of Firefly's 9th season. After years of fighting against the Alliance, Mal Reynolds is killed by Alliance deep cover agent River Tam.
Then the body glows, and Nathan Fillion changes into Charlie Sheen and is alive again. He just stood up and said "Call me the Captain.'
They called it a 'regeneration' in the season 10 premier. My friends as I were talking about that all summer long.