I feel like people definitely invented/jumped to some conclusions about Frost's shenanigans, I mean people literally made up stories about secret drug dens with pregnant waitresses, but there was always enough smoke to the drinking stuff to figure there was something going on there. That doesn't mean he was out on the town in clubs doing coke and hooking up with girls and getting into fistfights. To be honest, nothing about his (lack of) personality would point to him being a social butterfly party animal guy... But you can be a miserable unmotivated dude who drinks too much without being THAT particular stereotype. The last couple seasons he routinely looked hung over and disheveled and came across totally lethargic.
Also, Dean himself literally confirmed the story about Frost drinking too much to go to Dylan Raiola's recruiting visit.
WTF else needs to be said??