Whether via resurrection, ghostly apparition or afterlife sequence, dead characters often return in Supernatural, but these guys weren't so lucky.