I've spent a lot of time in Chevy Tahoes. Even did my counter-terrorism driving school in them.
I'm not going to try to sell you on the Z71 even though it is my favorite package. Is it necessary to go off-road? No. The Z71 package is basically the shocks, tires, and skid-plates. You also get the 2-speed transfer case (low range) and the 3.42 gears as well as the front spoiler deleted for extra clearance in the snow. But other than that it's not drastically different from the rest of the line. If you like the look of it great.
A few things to note:
1) The 3.42 gears do make a difference if you drive a lot on back roads and hills.
2) The Duratrac tires are excellent in snow/ice as well as pavement, but the braking distance is compromised a bit.
3) Skip the big 22" wheels. They drive like crap and have too much rotational mass.
4) Keep in mind that having 4WD does not make the Tahoe a good snow vehicle unless it has the right tires. 4WD gets you moving in the snow/ice, but it does nothing to stop you. That's where the right tires come into play.
5) Skid plates may or may not be your friend in heavy snow. It can act as a ramp (good and bad).
6) Try to get the full back seat versus those stupid captain's chairs.
FYI---the Duratrac tires are not uncomfortable. I've had them on 4 vehicles. You just have to learn how they drive. You'll either love them or hate them. But a personnal choice nonetheless. But all in all don't go with wheels any bigger than a 20" on a Tahoe. The 18s are ideal, and the 20s push the envelope a little.
Good luck.