I've never enjoyed it even as a highly sociable teenager.
It always seemed sad and desperate and I was also often on high alert for people who wanted a sly grope at midnight...there always seemed to be someone waiting to pounce at midnight.
Now I'm an adult, I've been to a number of NYE parties at people's houses and I don't like the desperate drinking...that's all anyone seems to do.
No actual fun like games or anything...I know some people like getting drunk but I don't so I suppose I've got to just move on.
DH is the same as me. We went last year to a party which friends of ours held and it wasn't good. There were all the children there...which is ok if the party is relatively sober but everyone guzzled so much champagne that it seemed a mess by midnight.
The kids had a room to hang out in...with videos but they all kept coming out and I wasn't happy with mine near all those drunk adults. I knew them all well but it didn't sit right.