I went there for UG, and to be honest, wasn't thrilled with the place. As you may have heard, the "city" stinks. Very industrial wasteland. The snow thing sounded nice before I actually got there (skiing! sledding!). It was not nice when combined with 30 mph gusts of wind while walking to class. Campus authorities pretty much clamped down on anything resembling fun after the Livingston riot during my freshman year. The funky bohemian coffee shop was forced out by Starbucks, also during my freshman year. Communal space narrowed down to a few bars overcrowded with greeks who were the worst drunks EVER.
Classes were hit-or-miss... some Arts and Sciences classes were built for morons. Newhouse and Maxwell were better. I did take one law class, which I enjoyed, so perhaps that bodes well. The law building is pretty new.
And, of course, bball and football lovers will be happy, though I'm still mad about the high cost of tickets.