You live in my neck of the woods. I'm in lower Fairfield county CT.
You can definitely have a good New Years without putting yourself in that position (trust me, drunk idiots have never been my favorite either, but mostly just because they act stupid and I have no patience). Is there someone you can hang out with at your apartment, get a few movies, some food (or make some food) and just have a chill night? It's hella cold out anyway.
that said, I do prefer to go out (I'm also guessing I'm older than you if all your friends are getting a hotel room and getting drunk lol), but really it's only because it's rare that my BF is off on NYE (he's in a band). This year he's off and we're away visiting family, so we're going to see his family, stop by a friend's for dinner and then probably end the night with movies and drinks at his brother's house.