There's an old saying about people:
All style and no substance.
That's when people have flair and ability, but lack the intangibles to take advantage of their talent.
Or, it can mean they're just crazy like Charlie Sheen.
The saying applies to baseball players too.
Here is a list of every team's all style and no substance players.