AWD + Winter > AWD + All-Season > FWD + Winter > FWD + All-Season
There are plenty of videos[1] showing the above. I guess it should come as no surprise that it comes down to the vehicle, the tires, the conditions, and the driver.
At least for me driving in the PNW (temps usually not too much below freezing), Kumho Crugens (all-season) on my AWD SUV are way superior to Michelin X-Ice (winter) on my FWD minivan. Braking is longer on snow and ice with all-seasons, so I leave 8 car lengths of distance minimum when following other cars. The SUV has superior ESC and traction control that way out perform the minivan.
Several times in my FWD minivan with winter tires, I have been unable to go uphill on icy roads and had to put on chains. Whereas the AWD has no issues at all.