think it would pay off but his NFL tenure or place among BYU QB greats are not why he would be worth the risk. I think he will be great, but not for this reason.
By this logic Gretzky would have been an amazing coach, but the "great one" was a bad hockey coach. Great Player /= Great Coach.