Snow mode in Boston
Being that Boston has seemed closer to Syracuse this winter, I've had my LR4 in and out of Snow mode constantly, and I agree with the other posters, any snow is fine.
All the modes (except for the last one for rock climbing) as far as I know, are about changing the suspension, traction via acceleration ramp time, etc. Many are things you could do yourself, but you'd have to be very efficient, and quite frankly the computer just does a better job. It has input from the wheels to see how they are slipping, etc. - things you really can't keep a constant eye on when you should be looking at where you're driving.
In my experience in snow, and especially in lots of thick ice in back alley parking spaces, the snow mode is amazing. In one bad storm, I breezed out of over a foot of packed snow and ice in our back alley. The wheel ruts were so deep, a few SUVs were getting stuck on the snow between the ruts. I just elevated my LR4 and sailed over them.
I liked my LR4 before this winter. Now I love it.