Wife and I went last year and stayed the night with the intent of heavily drinking. We went to several of the bars that night, and there was no one out. No one. It was really rough ridin' cold though...like 6 degrees cold.
I have heard that NYE is pretty cool when the weather is better.
I am going this year, but not staying after the game.