Brolin i believe had an ankle injury, I think but it might be a knee , any swedish football follower might be able to clear that up but i think he broke his ankle
Anyway players who self destructed that i can think of are Gazza, Best to name a few while players who never made it are evryone on this forum, 90% of football fans who go to stadia and and are armchair followers so to start naming those will take forever