I have lived in the northeast in Massachusetts and Connecticut and didn't mind the snow too much.; it was the ice storms that did me in. We had 17 ice storms about the time I was trying to decide whether or not to move to Georgia when my daughter was starting college.
Snow is pretty; I enjoy shoveling snow even when it's 3 feet deep. It was rather hard work during that blizzard in 1977 when the drifts were 7 and 8 feet tall. But I shoveled my way out of the house, strapped a wooden box onto an old sled, piled my daughter into the box and walked to Mom's house to visit and shovel her snow.
I think the old one gets, the less attractive snow becomes. The novelty wears off after awhile. The 'Snow Birds' have the right idea; enjoying their retirement years living in the south during the winter and going back up north to enjoy the summer.