HerHusband writes:

So, I'd like to hear how others deal with snow that falls erratically,
but can be a big problem when it does?

Well, you said best LONG TERM solution.
This is my favorite.

The DOE has a lot a nuclear waste they'd like to dispose of.
Encase it in cement and bury it under suburban driveways.

You'll never have to shovel again.

As long as you don't sleep in the driveway,
you'll be fine.