Not that I ever root for my team to lose, but this happened to the Lions last year. We were literally a 4 and 27 miracle reception from have the number two pick in the draft!
We were losing to the Saints, and down to our last posession, 4th and 27 yards, and a pass thrown into double coverage...