I would hope it has an effect.
It is very difficult to plan a season, install a system and then have it blown up by some stupid decision by a key player. Along the same lines it is strange to plan to "hold on" until player X returns from suspension.
A couple here and there that are worth the risk is fine. But when you have three or four of them running around, the risk taking thing becomes less desirable.
I'm with you and yet I look at a guy like Spence.
Got busted for ecstasy twice as a freshman and got kicked out of the Big Ten. Urban Meyer got him into an off campus rehab program where he went 4 days a week 4 hours a night and never missed a session, all while maintaining an above 3.0 GPA. He throws his phone in the trash with all his party friends numbers on it and walks from them. He decides to continue to improve and goes to Eastern Kentucky where he excelled on and off the field. He had a hiccup by throwing a bottle into a trash bin that missed and broke, a cop saw it and wrote him up for disorderly conduct but it was expunged and nothing came of it. He now says he doesn't even recognize that 18 year old who did that stuff.
If there's a Von Miller edge rusher in this draft - it's him and everyone agrees while Bosa is the safer pick - Spence has a much higher upside, like Charles Haley upside.
Everything you say is right about the risk of multiple players like this and no doubt we've used all of our chips already and if you called me an idiot for thinking like this I couldn't come back with anything, but much like Jerry - I can't help myself.
I think I would take a chance on him.