As a kid I loved it, because it usually meant no school, or a two hour late start if there was school. As kids we would take our sleds up the street and go sledding down the street it was great. We also had a large field next to the local school that had a huge hill that we would go sledding down too. So many great memories.
As an I adult I love it, because it usually means no school, and sometimes I get to stay home from work, so on those days we take advantage of it and have a family fun day of sledding with the kids. Lots of great memories there too. I also love waking up to the ground all white, as everything around us looks so beautiful and peaceful.
The part that sucks is that our snow usually turns to ice after a day or so, which makes it a pain to drive anywhere. Dry powder snow is great, but wet snow and snow that eventually becomes ice sucks! What also sucks is our driveway has a slope to it, so when it snows I have to shovel the driveway. That's no fun either, so as an adult its more of a love/hate thing. LOL