Looks like it might well have been Branko Zebec, Croatian former coach at Hamburg SV (Sport Verein)
https://www.bild.de/sport/fussball/1-bundesliga/hsv-trainer-schlief-besoffen-auf-der-bank-27494240.bild.html"Schlief besoffen auf der Bank" meaning he slept on the bench in a drunken state (while a game against Dortmund was being played)
He'd missed the team bus and followed in his car. Stopped by the Polizei for driving very slowly on the Autobahn, well over the limit. His manager Günter Netzer fetched him from the police station and took him to the team hotel, where he gave "a brilliant team-briefing" and then carried on drinking.
A well respected and successful coach, with an alcohol problem.
Is this the guy you were thinking of?