I live in southeastern Michigan. I've owned a 4x4 Dodge for 25 years, and I've owned many other FWD vehicles, as well as a few RWD cars over the years. I personally bought a AWD Telluride, to replace my 25 year old 4x4 pickup, because I really don't need a truck as much as I need a comfortable vehicle that can easily seat 3 or 4 adults and have room for 'stuff', as well as to be able to handle some light off road use, and pull a 3000lb + trailer from time to time.
I stopped driving my 4x4 when gas prices got high, and eventually bought a Chevy Cruze, which to drive back and forth to work ( 35 miles one way ). The Cruze had wide sport tires on it, and my wife got stuck in the driveway with about 2 inches of snow. I personally could have driven it without getting stuck that day, but I eventually bought another set of wheels, put some Bridgestone Blizzak tires on it. After putting the blizzak tires on the Cruze... wow, other then it's low ground clearance ( about 5 inches ) , I can drive my cruze with snow tires on it, anywhere and feel even safer than I did in my 4x4. The 4x4 will go through 10" of snow, no problem, even with all season tires on it, but it's not really safer. The Cruze has stability control, and with the snow tires on it, it feels like it's on rails in snow up to about 5 inches deep. I'm sold on snow tires, except... they are a pain in the butt to have to switch out.
I also owned a 2019
Sorento AWD, and drove it for one winter, with some very good Nokian 'all weather' WR G4 tires on it. It has stability control on it too, and effectively is the same drivetrain as the Telluride , only about 2" lower than a Telluride. It was a very stable and capable vehicle in the snow, but honestly I still think my Cruze with Blizzaks on it is just as stable and other than ground clearance, I personally feel I could drive anywhere in snow with my Cruze and snow tires, that I could go with my
Sorento with AWD and very good 'all weather' tires.
So, anyway... if you have room to store a set of wheels/tires , and your willing to take the time to swap them out every fall/spring, snow tires and FWD is a very capable setup for winter driving. But AWD is going to give you just a wee bit more forward traction in the worst winter conditions.
I personally, will probably switch my Pirelli tires out in a heartbeat for the Nokian WR G4 tires, if there's any sign that the Pirelli tires don't do a decent job in snow. I seriously doubt I'll ever run snow tires on my AWD Telluride, simply because it really is a pain in the butt to swap tires out twice a year, and I know my AWD and a good set of all weather tires will do the job for me.
As for FWD, vs AWD simply for snow... If I were tight on money and didn't do any real off road travel, I'd probably just stick with FWD. AWD won't help you stop... it will help you get up slippery hills... In the part of Michigan I live in, it's extremely rare that roads I travel will have snow on them for more than 24 hours, they plow and salt the roads quickly, usually dry pavement by the afternoon drive home.