It's a complex question. Hoyer's lack of situational awareness was to startling to see and it was probably the last thing I expected from him.
I simply don't see the value of having him on the team based on what he did on the field in KC. Yes, he had virtually no prep leading up to the game, but his decision making, was that of a Division 3 walk on. I could accept the hospital balls but his inability to understand the the context of where the team was at in both his red zone turnovers, was not a a level expected of a QB who has been in the league for a decade. I've always liked Hoyer but Johnny Foxboro would have made better decisions.
Stid is young and green and miles ahead of Hoyer in terms of ability. Hopefully, with a week of prep and not playing from behind, he won't be so cavalier with the football. If he is, then he has no future here. Ball security is one of Bills' fundamental tenants of offensive football. If you are making bad decisions and are turning the ball over, you have no place on the Patriots roster.