Not necessarily. There's a couple kinds of turds. The ones who work their tail off and are outspoken in ways the mainstream doesn't approve of, and the ones who slack off and coast on talent until that doesn't get them by anymore. I don't really know which Mayfield is.
Terrell Owens is an example of the former. He was considered difficult, surly, and a coaches problem, but he was also a big producer, legendarily hard worker, and kept himself in impeccable shape. Guys like him are what the NFL secretly loves (maybe not the teams but the league itself). If Mayfield has the skills and works his tail off, he can get away with the controversy.
Johnny Football was the latter. He was already kind of meh as an NFL talent, then he didn't work hard or take care of his body either. Then he didn't produce much. Once he started acting out the leash was very short.