However, if your manager did something inappropriate in private then whose side do you think HR will take?
You will be labelled as a troublemaker. That college hire will be in trouble as well (not for what he did, but because he has made the company vulnerable to action), but your record will be marked (almost certainly not literally; they're not stupid enough to outright leave actionable evidence like that).
I've heard far more success going outside HR channels - like say talking to a boss's boss or a boss's colleague.
It takes a whole-team revolt to beat a bad boss through HR channels, and most people aren't willing to put their careers at risk. Not only that, but after you beat a bad boss, you're still viewed with suspicion by managers ("protect our own") and will have a hard time getting a transfer or promotion.