Stafford definitely qualifies as a deadline day acquisition win for Sweeney. He won't be 32 until the start of next season so if he shows that he has the legs, I'd sign him for 3 years at Hayes money easily.
I am glad you are not the GM. I certainly would not consider signing him for three years. If he plays well, till year end maybe one year to give our young players more time to develope, but that is it. This is not a knock on Stafford . Just good team manegement.