One of the most important eras of superhero TV came to an end last night, and perhaps fittingly, it did so with a mix of sentiment and absolute insanity.