Kurt Warner should get an honorable mention to say the least.  He filled in for Trent Green after he blew out his knee in a preseason game.  Warner, et. al., the "Greatest Show on Turf."  They won the Superbowl, I think he was MVP, and even set a record or two.